schema/spacewalk/upgrade/spacewalk-schema-0.5-to-spacewalk-schema-0.6/998-postgresql-compatability-procs.sql
| 65 ++++++++++
1 file changed, 65 insertions(+)
New commits:
commit b9512f927b9d9630debf4ff2b4f367b4191f3e17
Author: Devan Goodwin <dgoodwin(a)redhat.com>
Date: Tue Jul 28 16:12:45 2009 -0300
Add upgrade scripts for PostgreSQL compat procedures.
Changes in 154cc866.
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.5-to-spacewalk-schema-0.6/998-postgresql-compatability-procs.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.5-to-spacewalk-schema-0.6/998-postgresql-compatability-procs.sql
new file mode 100644
index 0000000..23674ae
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.5-to-spacewalk-schema-0.6/998-postgresql-compatability-procs.sql
@@ -0,0 +1,65 @@
+---
+--- Add stored procedures for PostgreSQL compatability.
+---
+
+CREATE OR REPLACE VIEW
+rhnServerOutdatedPackages
+(
+ server_id,
+ package_name_id,
+ package_evr_id,
+ package_nvre,
+ errata_id,
+ errata_advisory
+)
+AS
+SELECT DISTINCT SNPC.server_id,
+ P.name_id,
+ P.evr_id,
+ PN.name || '-' || evr_t_as_vre_simple( PE.evr ),
+ E.id,
+ E.advisory
+ FROM rhnPackageName PN,
+ rhnPackageEVR PE,
+ rhnPackage P,
+ rhnServerNeededPackageCache SNPC
+ left outer join
+ rhnErrata E
+ on SNPC.errata_id = E.id
+ WHERE SNPC.package_id = P.id
+ AND P.name_id = PN.id
+ AND P.evr_id = PE.id;
+
+create or replace function evr_t_as_vre( a evr_t )
+ return varchar2
+is
+begin
+ return a.as_vre;
+end;
+
+create or replace function evr_t_as_vre_simple( a evr_t )
+ return VARCHAR2
+is
+begin
+ return a.as_vre_simple;
+end;
+
+create or replace function sequence_currval( seq_name varchar2 ) return number as
+ ret number;
+begin
+ execute immediate 'select '|| seq_name || '.currval from dual'
+ into ret;
+ return ret;
+end;
+
+create or replace function sequence_nextval( seq_name varchar2 ) return number as
+ ret number;
+begin
+ execute immediate 'select '|| seq_name || '.nextval from dual'
+ into ret;
+ return ret;
+end;
+
+
+
+
Show replies by date