Changeset 1404

Timestamp:

Jan 18, 2011, 10:52:46 AM (10 years ago)

Author:

business@…

Message:

small fix

File:

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

trunk/grails-app/conf/DatabaseUpgrade.groovy

@@ -106 +106 @@
                 if (db == "org.postgresql.Driver") {
                         // check if any TEXT template fields are of type 'text'
-                        sql.eachRow("SELECT columns.table_name FROM information_schema.columns WHERE columns.table_schema::text = 'public'::text AND column_name='template_text_fields_elt' AND data_type != 'text';")
+                        sql.eachRow("SELECT columns.table_name as tablename FROM information_schema.columns WHERE columns.table_schema::text = 'public'::text AND column_name='template_text_fields_elt' AND data_type != 'text';")
                         { row ->
-                                "performing database upgrade: ${row.table_name} template_text_fields_string/elt to text".grom()
+                                "performing database upgrade: ${row.tablename} template_text_fields_string/elt to text".grom()
                                 try {
                                         // change the datatype of study::description to text
-                                        sql.execute("ALTER TABLE ${row.table_name} ALTER COLUMN template_text_fields_elt TYPE text")
-                                        sql.execute("ALTER TABLE ${row.table_name} ALTER COLUMN template_text_fields_string TYPE text")
+                                        sql.execute("ALTER TABLE ${row.tablename} ALTER COLUMN template_text_fields_elt TYPE text")
+                                        sql.execute("ALTER TABLE ${row.tablename} ALTER COLUMN template_text_fields_string TYPE text")
 
                                 } catch (Exception e) {