schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/144-rhnTimezone-data.sql
| 2 +-
schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/146-rhnDistChannelMap-data.sql
| 2 +-
2 files changed, 2 insertions(+), 2 deletions(-)
New commits:
commit 00f2903853d3a63377f3c749ce21e87da3279ffc
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Wed Oct 31 15:08:22 2012 +0100
Fixing syntax.
Addressing
psql:/var/log/spacewalk/schema-upgrade/20121031-094201-script.sql:2414: ERROR: column
"dcm" of relation "rhndistchannelmap" does not exist
LINE 1: UPDATE rhnDistChannelMap dcm SET dcm.org_id = (SELECT c.org_...
^
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/146-rhnDistChannelMap-data.sql
b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/146-rhnDistChannelMap-data.sql
index 948a329..4d26cd6 100644
---
a/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/146-rhnDistChannelMap-data.sql
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/146-rhnDistChannelMap-data.sql
@@ -1 +1 @@
-UPDATE rhnDistChannelMap dcm SET dcm.org_id = (SELECT c.org_id FROM rhnChannel c where
c.id = dcm.channel_id);
+UPDATE rhnDistChannelMap dcm SET org_id = (SELECT c.org_id FROM rhnChannel c where c.id =
dcm.channel_id);
commit a2a9cdaea474e0dfc17fa565323757190779a3df
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Wed Oct 31 14:39:17 2012 +0100
Fixing syntax.
Addressing
psql:/var/log/spacewalk/schema-upgrade/20121031-071549-script.sql:2386: ERROR:
missing FROM-clause entry for table "rhn_timezone_id_seq"
LINE 2: VALUES (rhn_timezone_id_seq.nextval,
^
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/144-rhnTimezone-data.sql
b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/144-rhnTimezone-data.sql
index 2f0894e..d747c69 100644
---
a/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/144-rhnTimezone-data.sql
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/144-rhnTimezone-data.sql
@@ -1,3 +1,3 @@
INSERT INTO rhnTimezone (id, olson_name, display_name)
-VALUES (rhn_timezone_id_seq.nextval,
+VALUES (sequence_nextval('rhn_timezone_id_seq'),
'Africa/Johannesburg', 'South Africa (Johannesburg)');
Show replies by date