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@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@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)');
spacewalk-commits@lists.fedorahosted.org