schema/spacewalk/oracle/procs/lookup_erratafile_type.sql
| 1
schema/spacewalk/postgres/procs/lookup_erratafile_type.sql
| 2 -
schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/095-lookup_erratafile_type.sql.oracle
| 18 ++++++++++
schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/095-lookup_erratafile_type.sql.postgresql
| 2 +
4 files changed, 21 insertions(+), 2 deletions(-)
New commits:
commit 807f0f1fddb0cf9c4c4d1d1a0e826f850a4ff67a
Author: Milan Zazrivec <mzazrivec(a)redhat.com>
Date: Tue Feb 28 11:56:27 2012 +0100
no need for autonomous_transaction in lookup_erratafile_type
diff --git a/schema/spacewalk/oracle/procs/lookup_erratafile_type.sql
b/schema/spacewalk/oracle/procs/lookup_erratafile_type.sql
index d654322..4f9e42f 100644
--- a/schema/spacewalk/oracle/procs/lookup_erratafile_type.sql
+++ b/schema/spacewalk/oracle/procs/lookup_erratafile_type.sql
@@ -20,7 +20,6 @@ create or replace function
lookup_erratafile_type (
label_in in varchar2
) return number deterministic is
- pragma autonomous_transaction;
erratafile_type_id number;
begin
select id
diff --git a/schema/spacewalk/postgres/procs/lookup_erratafile_type.sql
b/schema/spacewalk/postgres/procs/lookup_erratafile_type.sql
index 5508a15..a155791 100644
--- a/schema/spacewalk/postgres/procs/lookup_erratafile_type.sql
+++ b/schema/spacewalk/postgres/procs/lookup_erratafile_type.sql
@@ -1,4 +1,4 @@
--- oracle equivalent source sha1 f4a1877eeefcbdfd668fc2863fddedc7ae727fbb
+-- oracle equivalent source sha1 c37ec2fbd380eb992f2064563a80abb3a0d8f9ce
-- retrieved from
./1241042199/53fa26df463811901487b608eecc3f77ca7783a1/schema/spacewalk/oracle/procs/lookup_erratafile_type.sql
--
-- Copyright (c) 2008--2010 Red Hat, Inc.
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/095-lookup_erratafile_type.sql.oracle
b/schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/095-lookup_erratafile_type.sql.oracle
new file mode 100644
index 0000000..3ad9ec1
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/095-lookup_erratafile_type.sql.oracle
@@ -0,0 +1,18 @@
+create or replace function
+lookup_erratafile_type (
+ label_in in varchar2
+) return number deterministic is
+ erratafile_type_id number;
+begin
+ select id
+ into erratafile_type_id
+ from rhnErrataFileType
+ where label = label_in;
+
+ return erratafile_type_id;
+exception
+ when no_data_found then
+ rhn_exception.raise_exception('erratafile_type_not_found');
+end;
+/
+show errors
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/095-lookup_erratafile_type.sql.postgresql
b/schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/095-lookup_erratafile_type.sql.postgresql
new file mode 100644
index 0000000..03797a9
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/095-lookup_erratafile_type.sql.postgresql
@@ -0,0 +1,2 @@
+-- oracle equivalent source sha1 d8619ed90fe5a61425ec2e61bbb46a0cbb99ead3
+-- This file is intentionally left empty.
Show replies by date