rel-eng/packages/spacewalk-schema
| 2 +-
schema/spacewalk/spacewalk-schema.spec
| 5 ++++-
schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/145-rhnDistChannelMap.sql.oracle
| 2 +-
3 files changed, 6 insertions(+), 3 deletions(-)
New commits:
commit aded3063f817b9a0f92c8c13980571d1ce97ffba
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Thu Nov 1 18:57:15 2012 +0100
Automatic commit of package [spacewalk-schema] release [1.8.87-1].
diff --git a/rel-eng/packages/spacewalk-schema b/rel-eng/packages/spacewalk-schema
index ea436fc..9f08d2d 100644
--- a/rel-eng/packages/spacewalk-schema
+++ b/rel-eng/packages/spacewalk-schema
@@ -1 +1 @@
-1.8.86-1 schema/spacewalk/
+1.8.87-1 schema/spacewalk/
diff --git a/schema/spacewalk/spacewalk-schema.spec
b/schema/spacewalk/spacewalk-schema.spec
index 37f1ddd..dcef821 100644
--- a/schema/spacewalk/spacewalk-schema.spec
+++ b/schema/spacewalk/spacewalk-schema.spec
@@ -2,7 +2,7 @@ Name: spacewalk-schema
Group: Applications/Internet
Summary: Oracle SQL schema for Spacewalk server
-Version: 1.8.86
+Version: 1.8.87
Release: 1%{?dist}
Source0: %{name}-%{version}.tar.gz
@@ -68,6 +68,9 @@ rm -rf $RPM_BUILD_ROOT
%{_mandir}/man1/spacewalk-sql*
%changelog
+* Thu Nov 01 2012 Jan Pazdziora 1.8.87-1
+- Cannot drop index used for enforcement of unique/primary key.
+
* Wed Oct 31 2012 Jan Pazdziora 1.8.86-1
- The index might not actually exist.
- Fixing syntax.
commit 5d19dfd40a7ba7acac48ebedca9b3b6f2f6a0fce
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Thu Nov 1 18:51:30 2012 +0100
Cannot drop index used for enforcement of unique/primary key.
Addressing
DROP INDEX rhn_dcm_os_release_caid_idx
*
ERROR at line 1:
ORA-02429: cannot drop index used for enforcement of unique/primary key
(cherry picked from commit 874dc5cb344d940fbda74e83f2509b7ebc377872)
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/145-rhnDistChannelMap.sql.oracle
b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/145-rhnDistChannelMap.sql.oracle
index 31b61b8..423bd06 100644
---
a/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/145-rhnDistChannelMap.sql.oracle
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/145-rhnDistChannelMap.sql.oracle
@@ -1,7 +1,7 @@
ALTER TABLE rhnDistChannelMap ADD org_id NUMBER;
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;
ALTER TABLE rhnDistChannelMap DROP CONSTRAINT rhn_dcm_os_release_caid_uq;
+DROP INDEX rhn_dcm_os_release_caid_idx;
ALTER TABLE rhnDistChannelMap ADD CONSTRAINT rhn_dcm_release_caid_oid_uq UNIQUE (release,
channel_arch_id, org_id);
ALTER TABLE rhnDistChannelMap ADD id NUMBER;
Show replies by date