Author: tchemit Date: 2013-12-16 16:32:13 +0100 (Mon, 16 Dec 2013) New Revision: 909 Url: http://forge.codelutin.com/projects/echobase/repository/revisions/909 Log: fixes #4019: Probl?\195?\168me de mise ?\195?\160 jour des donn?\195?\169es spatiales d'op?\195?\169ration Modified: trunk/echobase-services/src/main/resources/postgis-structure.sql Modified: trunk/echobase-services/src/main/resources/postgis-structure.sql =================================================================== --- trunk/echobase-services/src/main/resources/postgis-structure.sql 2013-12-16 15:16:01 UTC (rev 908) +++ trunk/echobase-services/src/main/resources/postgis-structure.sql 2013-12-16 15:32:13 UTC (rev 909) @@ -1084,8 +1084,8 @@ -- create row RAISE DEBUG 'Will create spatial operation %', operation_id; -- get operation infos - SELECT op.id - INTO operationName + SELECT op.id, op.topiaid + INTO operationName, operationId FROM operation op WHERE op.topiaid = operation_id; -- get transect infos @@ -1111,13 +1111,13 @@ WHERE t.topiaid = transitId AND v.topiaid = t.voyage; INSERT INTO echobase_operation_spatial (lastUpdateDate, voyageid, voyagename, transitid, transitname, transectid, transectname, operationid, operationname, coordinate) - VALUES (now(), voyageId, voyageName, transitId, transitName, transectId, transectName, operation_id, operationName, coordinateData); + VALUES (now(), voyageId, voyageName, transitId, transitName, transectId, transectName, operationId, operationName, coordinateData); ELSE -- update row RAISE DEBUG 'Will update spatial operation % ', operation_id; - UPDATE echobase_operation_spatial - SET coordinate = coordinateData - WHERE operationid = operation_id; + UPDATE echobase_operation_spatial eos + SET eos.coordinate = coordinateData + WHERE eos.operationid = operation_id; END IF; END $$ LANGUAGE plpgsql;