Author: tchemit Date: 2014-04-17 11:38:52 +0200 (Thu, 17 Apr 2014) New Revision: 1010 Url: http://forge.codelutin.com/projects/echobase/repository/revisions/1010 Log: fixes #4948 Modified: trunk/echobase-domain/src/main/resources/migration/postgis-structure-2.6.1.sql trunk/echobase-domain/src/main/resources/postgis-structure.sql Modified: trunk/echobase-domain/src/main/resources/migration/postgis-structure-2.6.1.sql =================================================================== --- trunk/echobase-domain/src/main/resources/migration/postgis-structure-2.6.1.sql 2014-04-17 09:20:20 UTC (rev 1009) +++ trunk/echobase-domain/src/main/resources/migration/postgis-structure-2.6.1.sql 2014-04-17 09:38:52 UTC (rev 1010) @@ -224,9 +224,9 @@ ELSE -- update row RAISE DEBUG 'Will update spatial operation % ', operation_id; - UPDATE echobase_operation_spatial + UPDATE echobase_operation_spatial AS eos SET coordinate = coordinateData - WHERE operationid = operation_id; + WHERE eos.operationid = operation_id; END IF; END $$ LANGUAGE plpgsql; \ No newline at end of file Modified: trunk/echobase-domain/src/main/resources/postgis-structure.sql =================================================================== --- trunk/echobase-domain/src/main/resources/postgis-structure.sql 2014-04-17 09:20:20 UTC (rev 1009) +++ trunk/echobase-domain/src/main/resources/postgis-structure.sql 2014-04-17 09:38:52 UTC (rev 1010) @@ -1227,9 +1227,9 @@ ELSE -- update row RAISE DEBUG 'Will update spatial operation % ', operation_id; - UPDATE echobase_operation_spatial + UPDATE echobase_operation_spatial AS eos SET coordinate = coordinateData - WHERE operationid = operation_id; + WHERE eos.operationid = operation_id; END IF; END $$ LANGUAGE plpgsql;