schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/145-rhnDistChannelMap.sql.postgresql
| 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit 28994c4547090e1d541090d6ea7718f3ae4ee88d
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Wed Oct 31 16:57:55 2012 +0100
The index might not actually exist.
Addressing
psql:/var/log/spacewalk/schema-upgrade/20121031-104227-script.sql:15578: ERROR: index
"rhn_dcm_os_release_caid_idx" does not exist
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/145-rhnDistChannelMap.sql.postgresql
b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/145-rhnDistChannelMap.sql.postgresql
index 08fa0fa..654f2f3 100644
---
a/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/145-rhnDistChannelMap.sql.postgresql
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/145-rhnDistChannelMap.sql.postgresql
@@ -2,7 +2,7 @@
ALTER TABLE rhnDistChannelMap ADD org_id NUMERIC;
ALTER TABLE rhnDistChannelMap ADD CONSTRAINT rhn_dcm_oid_fk FOREIGN KEY (org_id)
REFERENCES web_customer (id) ON DELETE CASCADE;
-DROP INDEX rhn_dcm_os_release_caid_idx;
+DROP INDEX if exists rhn_dcm_os_release_caid_idx;
ALTER TABLE rhnDistChannelMap DROP CONSTRAINT rhn_dcm_os_release_caid_uq;
ALTER TABLE rhnDistChannelMap ADD CONSTRAINT rhn_dcm_release_caid_oid_uq UNIQUE (release,
channel_arch_id, org_id);
Show replies by date