Author: tchemit Date: 2012-04-13 18:33:50 +0200 (Fri, 13 Apr 2012) New Revision: 3265 Url: http://chorem.org/repositories/revision/pollen/3265 Log: fix migration script for pg Modified: trunk/pollen-persistence/src/main/java/org/chorem/pollen/entities/migration/PollenMigrationCallbackV1_3.java Modified: trunk/pollen-persistence/src/main/java/org/chorem/pollen/entities/migration/PollenMigrationCallbackV1_3.java =================================================================== --- trunk/pollen-persistence/src/main/java/org/chorem/pollen/entities/migration/PollenMigrationCallbackV1_3.java 2012-04-13 16:27:58 UTC (rev 3264) +++ trunk/pollen-persistence/src/main/java/org/chorem/pollen/entities/migration/PollenMigrationCallbackV1_3.java 2012-04-13 16:33:50 UTC (rev 3265) @@ -91,7 +91,7 @@ queries.add("ALTER TABLE comment ADD COLUMN author VARCHAR(255);"); - queries.add("UPDATE comment AS c SET c.author = (SELECT p.votingId FROM pollAccount p WHERE c.pollAccount = p.topiaId);"); + queries.add("UPDATE comment AS c SET author = (SELECT p.votingId FROM pollAccount p WHERE c.pollAccount = p.topiaId);"); queries.add("ALTER TABLE comment ALTER COLUMN author TYPE VARCHAR(255);"); queries.add("UPDATE comment SET author = 'anonymous' WHERE author IS NULL;");