schema/spacewalk/postgres/triggers/rhnErrataPackage.sql
| 2 -
schema/spacewalk/upgrade/spacewalk-schema-1.3-to-spacewalk-schema-1.4/012-rhn_errata_package_mod_trig_fun.sql.oracle
| 1
schema/spacewalk/upgrade/spacewalk-schema-1.3-to-spacewalk-schema-1.4/012-rhn_errata_package_mod_trig_fun.sql.postgresql
| 19 ++++++++++
3 files changed, 21 insertions(+), 1 deletion(-)
New commits:
commit 8fbc8e2d65ffcd59fd0c45c7d797cac0f0aa41cb
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Wed Mar 23 09:21:23 2011 +0100
In update, the column names should not contain table name (PostgreSQL).
Addressing
ERROR com.redhat.rhn.common.db.datasource.CachedStatement - Error while processing
cached statement sql: delete from rhnErrataPackage where errata_id in
(select element from rhnSet S where S.label = ? and S.user_id = ?)
com.redhat.rhn.common.db.WrappedSQLException: ERROR: column "rhnerrata" of
relation "rhnerrata" does not exist
diff --git a/schema/spacewalk/postgres/triggers/rhnErrataPackage.sql
b/schema/spacewalk/postgres/triggers/rhnErrataPackage.sql
index 4d5e092..96b2522 100644
--- a/schema/spacewalk/postgres/triggers/rhnErrataPackage.sql
+++ b/schema/spacewalk/postgres/triggers/rhnErrataPackage.sql
@@ -29,7 +29,7 @@ begin
end if;
if tg_op='DELETE' then
update rhnErrata
- set rhnErrata.last_modified = current_timestamp
+ set last_modified = current_timestamp
where rhnErrata.id in ( old.errata_id );
return old;
end if;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.3-to-spacewalk-schema-1.4/012-rhn_errata_package_mod_trig_fun.sql.oracle
b/schema/spacewalk/upgrade/spacewalk-schema-1.3-to-spacewalk-schema-1.4/012-rhn_errata_package_mod_trig_fun.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.3-to-spacewalk-schema-1.4/012-rhn_errata_package_mod_trig_fun.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.3-to-spacewalk-schema-1.4/012-rhn_errata_package_mod_trig_fun.sql.postgresql
b/schema/spacewalk/upgrade/spacewalk-schema-1.3-to-spacewalk-schema-1.4/012-rhn_errata_package_mod_trig_fun.sql.postgresql
new file mode 100644
index 0000000..822e91f
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.3-to-spacewalk-schema-1.4/012-rhn_errata_package_mod_trig_fun.sql.postgresql
@@ -0,0 +1,19 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+
+create or replace function rhn_errata_package_mod_trig_fun() returns trigger
+as
+$$
+begin
+ if tg_op='INSERT' or tg_op='UPDATE' then
+ new.modified := current_timestamp;
+ return new;
+ end if;
+ if tg_op='DELETE' then
+ update rhnErrata
+ set last_modified = current_timestamp
+ where rhnErrata.id in ( old.errata_id );
+ return old;
+ end if;
+end;
+$$ language plpgsql;
+
Show replies by date