Hello Admin,
Have you tried update table with "with timezone" data type?
I think there is a bug when you try to update data from different timezone.
I came accross many "DB concurrency violation" error when trying to update table that has timestamp with timezone type. The problem was gone when i changed to timestamp without timezone type.
I think you should check this out.
Thanks & Regards,
Ariwibawa
nb:sorry for my bad english
support for data type timestamp with timezone
Ariwibawa, I cannot reproduce the issue with the 4.55.39 version of dotConnect for PostgreSQL. The server was located on the machine with the +02:00 time zone, my machine had the +04:00 time zone. I have created the table with the time with time zone and timestamp with time zone columns. Then I updated this table via PgSqlTable in design time successfully. Please try using the 4.55.39 version. If the problem persits, please send us a test project with the DDL/DML script, and the description of your environment via our contact form ( http://www.devart.com/company/contact.html ).