Hello everybody
I'm absolutely not a postgresql/postgis guru
I need to populate a postgresql/postgis table with microsoft access.
In Qgis I add the geometries and then I use MS Access to add most of the
tabular data.
To map the user who makes the last modification to the values I made a
trigger function like this:
CREATE OR REPLACE FUNCTION myschema.myfunction()
RETURNS trigger AS
$BODY$
BEGIN
new.user_modif =current_user;
new.data_modif = now();
RETURN NEW;
END;
$BODY$
LANGUAGE plpgsql VOLATILE
COST 100;
ALTER FUNCTION myschema.myfunction()
OWNER TO myself;
It is invoched by this trigger:
CREATE TRIGGER set_user_date_mod
BEFORE UPDATE
ON myschema.mytable
FOR EACH ROW
EXECUTE PROCEDURE myschema.myfunction();
This trigger works and if I modify any value in the table user and timestamp
are correctly written at theyr place..
Then I encounter problems in other modification I want to perform on some
previously modificated rows..
Access can't save modifications and tells me there is another user (myself)
who has done some modification on the records that could be lost, and I
can't save..
Otherwise I can modify any other record.. And when modifyed that record is
not updatable anymore and so on..
Where is the problem?
I think there shoul be some transaction that dont come to the end and the
record remains "appended"..
Is it possible??
Any solution?
Thanks
Pietro
--
View this message in context:
http://postgis.17.x6.nabble.com/unable-to-modyfy-records-after-trigger-execution-tp5007158.html
Sent from the PostGIS - User mailing list archive at Nabble.com.
_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
