schema/spacewalk/oracle/procs/lookup_config_info.sql
| 1 -
schema/spacewalk/postgres/procs/insert_config_info.sql
| 2 +-
schema/spacewalk/postgres/procs/lookup_config_info.sql
| 2 +-
schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/093-lookup_config_info.sql.oracle
| 1 -
schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/093-lookup_config_info.sql.postgresql
| 2 +-
5 files changed, 3 insertions(+), 5 deletions(-)
New commits:
commit 63c160544134a7d32cbb4bc1489cd775ab8fd6a8
Author: Milan Zazrivec <mzazrivec(a)redhat.com>
Date: Tue Feb 28 11:13:10 2012 +0100
we don't need the autonomous_transaction pragma in lookup_config_info anymore
diff --git a/schema/spacewalk/oracle/procs/lookup_config_info.sql
b/schema/spacewalk/oracle/procs/lookup_config_info.sql
index 8769931..2525507 100644
--- a/schema/spacewalk/oracle/procs/lookup_config_info.sql
+++ b/schema/spacewalk/oracle/procs/lookup_config_info.sql
@@ -21,7 +21,6 @@ lookup_config_info (
) return number
deterministic
is
- pragma autonomous_transaction;
v_id number;
cursor lookup_cursor is
select id
diff --git a/schema/spacewalk/postgres/procs/insert_config_info.sql
b/schema/spacewalk/postgres/procs/insert_config_info.sql
index a43dd9b..18667b7 100644
--- a/schema/spacewalk/postgres/procs/insert_config_info.sql
+++ b/schema/spacewalk/postgres/procs/insert_config_info.sql
@@ -1,2 +1,2 @@
--- oracle equivalent source sha1 927ed17ae7b2c43d40e5a397f793ad986f7ba410
+-- oracle equivalent source sha1 ac28a1215137bf44831e56f3592afb2ef71a7042
-- This file is intentionally left empty.
diff --git a/schema/spacewalk/postgres/procs/lookup_config_info.sql
b/schema/spacewalk/postgres/procs/lookup_config_info.sql
index 980be5a..7e729bd 100644
--- a/schema/spacewalk/postgres/procs/lookup_config_info.sql
+++ b/schema/spacewalk/postgres/procs/lookup_config_info.sql
@@ -1,4 +1,4 @@
--- oracle equivalent source sha1 d6f51503a2c3261083fa31ce1bb1343c718292c1
+-- oracle equivalent source sha1 3f919d54835de5605f895ca1c76f90e6deb80bfb
--
-- Copyright (c) 2008--2010 Red Hat, Inc.
--
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/093-lookup_config_info.sql.oracle
b/schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/093-lookup_config_info.sql.oracle
index 048d825..3218dfa 100644
---
a/schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/093-lookup_config_info.sql.oracle
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/093-lookup_config_info.sql.oracle
@@ -29,7 +29,6 @@ lookup_config_info (
) return number
deterministic
is
- pragma autonomous_transaction;
v_id number;
cursor lookup_cursor is
select id
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/093-lookup_config_info.sql.postgresql
b/schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/093-lookup_config_info.sql.postgresql
index 1ba81f8..5929d14 100644
---
a/schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/093-lookup_config_info.sql.postgresql
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/093-lookup_config_info.sql.postgresql
@@ -1,4 +1,4 @@
--- oracle equivalent source sha1 972edb1a123761b8e7d7e239455bff1bae2307b1
+-- oracle equivalent source sha1 c342d6d7cd96eb4c99b64d8d8449aea4c89ad10a
--
-- Copyright (c) 2008--2010 Red Hat, Inc.
--
Show replies by date