[postgis-users] unable to modify records after trigger execution

Pietro Rossin pierigis at gmail.com
Thu Nov 13 00:23:45 PST 2014


Hello everybody
I got the answer to the trigger problem by myself digging around the web..

This is the problem with access >= 2007

http://www.postgresql.org/message-id/A434C531E37AD442815608A769550D8059425A3E00@EGEXCMB01.oww.root.lcl

The problem is that Access cannot handle date field type with 10-6 sec
resolution (it can deal with 10-3 sec resolution) and gives a wrong error
message (concurrent editing..??)

Changing the column to timestamp(0) solves the problem.

Ciao!




--
View this message in context: http://postgis.17.x6.nabble.com/unable-to-modify-records-after-trigger-execution-tp5007158p5007315.html
Sent from the PostGIS - User mailing list archive at Nabble.com.


More information about the postgis-users mailing list