schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/002-rhn_db_environment-rhn_environment-drop.sql
| 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit 031bd4f0c5aaa5079f14bcc48b0a136044b52ef5
Author: Milan Zazrivec <mzazrivec(a)redhat.com>
Date: Mon Nov 30 11:32:15 2009 +0100
Drop tables in correct order
rhn_db_environment references rhn_environment(name). We need to swap
the order in which we drop the tables to avoid following error:
ORA-02449: unique/primary keys in table referenced by foreign keys
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/002-rhn_db_environment-rhn_environment-drop.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/002-rhn_db_environment-rhn_environment-drop.sql
index b601a7d..489d2f4 100644
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/002-rhn_db_environment-rhn_environment-drop.sql
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/002-rhn_db_environment-rhn_environment-drop.sql
@@ -9,5 +9,5 @@ alter table rhn_config_macro add constraint rhn_confm_name_pk primary key
(name)
alter table rhn_config_macro drop column environment;
-drop table rhn_environment;
drop table rhn_db_environment;
+drop table rhn_environment;
Show replies by date