Changeset 1534 for trunk/grails-app/conf/DatabaseUpgrade.groovy

Timestamp:

Feb 17, 2011, 3:29:16 PM (12 years ago)

Author:

t.w.abma@…

Message:

• added check to database upgrade SQL query to drop constraint for field name in MappingColumn?

File:

• trunk/grails-app/conf/DatabaseUpgrade.groovy (modified) (1 diff)

trunk/grails-app/conf/DatabaseUpgrade.groovy

@@ -184 +184 @@
            if (db == "org.postgresql.Driver") {
                    try {
-                           sql.execute("ALTER TABLE mapping_column DROP CONSTRAINT mapping_column_name_key")
+                // Check if constraint still exists
+                if (sql.firstRow("SELECT * FROM pg_constraint WHERE contype='mapping_column_name_key"))
+                    sql.execute("ALTER TABLE mapping_column DROP CONSTRAINT mapping_column_name_key")
+                else
+                    println "changeMappingColumnNameConstraint exiting, constraint doesn't exist"
+
                    } catch (Exception e) {
                            println "changeMappingColumnNameConstraint `name` field unique constraint couldn't be dropped: " + e.getMessage()