schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/125-alter-index-rhnRam.sql
| 15 +++++++---
1 file changed, 11 insertions(+), 4 deletions(-)
New commits:
commit 99317e6fdf60d950277842e7818fb46f9a8e0ca0
Author: Milan Zazrivec <mzazrivec(a)redhat.com>
Date: Thu May 23 16:08:51 2013 +0200
Don't create index if it already exists
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/125-alter-index-rhnRam.sql
b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/125-alter-index-rhnRam.sql
index 9d8104f..18a9522 100644
---
a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/125-alter-index-rhnRam.sql
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/125-alter-index-rhnRam.sql
@@ -16,7 +16,14 @@ exception
end;
/
-CREATE UNIQUE INDEX rhn_ram_sid_uq
- ON rhnRam (server_id)
- TABLESPACE [[4m_tbs]]
- NOLOGGING;
+declare
+ name_already_used exception;
+ pragma exception_init(name_already_used, -00955);
+begin
+ execute immediate 'create unique index rhn_ram_sid_uq on rhnRam(server_id)
tablespace [[4m_tbs]] nologging';
+ dbms_output.put_line('Index rhn_ram_sid_uq successfully created.');
+exception
+ when name_already_used then
+ dbms_output.put_line('Index rhn_ram_sid_uq already exists.');
+end;
+/
Show replies by date