Author: fdesbois Date: 2010-04-19 21:56:02 +0000 (Mon, 19 Apr 2010) New Revision: 458 Log: Evo #2100 : Correct migration query for validationProgram constraint Modified: trunk/wao-business/src/main/java/fr/ifremer/wao/PostgresMigrationCallback.java Modified: trunk/wao-business/src/main/java/fr/ifremer/wao/PostgresMigrationCallback.java =================================================================== --- trunk/wao-business/src/main/java/fr/ifremer/wao/PostgresMigrationCallback.java 2010-04-19 21:44:50 UTC (rev 457) +++ trunk/wao-business/src/main/java/fr/ifremer/wao/PostgresMigrationCallback.java 2010-04-19 21:56:02 UTC (rev 458) @@ -97,7 +97,8 @@ "date_part('month', S.periodDate)" + " AND date_part('year', C.tideBeginDate) = " + "date_part('year', S.periodDate)" + - " AND C.validationProgram != FALSE" + + " AND (C.validationProgram != FALSE OR " + + " C.validationProgram IS NULL)" + "), " + "topiaVersion = S.topiaVersion + 1;"); }