Changeset 1574 for trunk

Timestamp:

Feb 28, 2011, 12:13:55 PM (10 years ago)

Author:

work@…

Message:

• updated mapping name column constraint database upgrade function to be more in line with the rest

File:

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

trunk/grails-app/conf/DatabaseUpgrade.groovy

@@ -185 +185 @@
                    try {
                 // Check if constraint still exists
-                if (sql.firstRow("SELECT * FROM pg_constraint WHERE contype='mapping_column_name_key'"))
+                if (sql.firstRow("SELECT * FROM pg_constraint WHERE contype='mapping_column_name_key'")) {
+                        println "performing database upgrade: mapping column name constraint"
                     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()