schema/spacewalk/postgres/packages/rhn_channel.pkb
| 2 -
schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/125-rhn_channel-obtain_read_lock.pkb.sql.oracle
| 1
schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/125-rhn_channel-obtain_read_lock.pkb.sql.postgresql
| 18 ++++++++++
3 files changed, 20 insertions(+), 1 deletion(-)
New commits:
commit 9ff3510a2f3c1420b8a5bbabf9697486acf2cc7f
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Wed Sep 5 13:05:51 2012 +0200
Make the into variable match the data type of the table column.
diff --git a/schema/spacewalk/postgres/packages/rhn_channel.pkb
b/schema/spacewalk/postgres/packages/rhn_channel.pkb
index e06892a..aa539c1 100644
--- a/schema/spacewalk/postgres/packages/rhn_channel.pkb
+++ b/schema/spacewalk/postgres/packages/rhn_channel.pkb
@@ -25,7 +25,7 @@ update pg_settings set setting = 'rhn_channel,' || setting where
name = 'search_
create or replace function obtain_read_lock(channel_family_id_in in numeric,
org_id_in in numeric)
returns void as $$
declare
- read_lock date;
+ read_lock timestamptz;
begin
select created into read_lock
from rhnPrivateChannelFamily
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/125-rhn_channel-obtain_read_lock.pkb.sql.oracle
b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/125-rhn_channel-obtain_read_lock.pkb.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/125-rhn_channel-obtain_read_lock.pkb.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/125-rhn_channel-obtain_read_lock.pkb.sql.postgresql
b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/125-rhn_channel-obtain_read_lock.pkb.sql.postgresql
new file mode 100644
index 0000000..2ae326e
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/125-rhn_channel-obtain_read_lock.pkb.sql.postgresql
@@ -0,0 +1,18 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+
+--update pg_setting
+update pg_settings set setting = 'rhn_channel,' || setting where name =
'search_path';
+
+ create or replace function obtain_read_lock(channel_family_id_in in numeric,
org_id_in in numeric)
+ returns void as $$
+ declare
+ read_lock timestamptz;
+ begin
+ select created into read_lock
+ from rhnPrivateChannelFamily
+ where channel_family_id = channel_family_id_in and org_id = org_id_in
+ for update;
+ end$$ language plpgsql;
+
+-- restore the original setting
+update pg_settings set setting = overlay( setting placing '' from 1 for
(length('rhn_channel')+1) ) where name = 'search_path';
Show replies by date