support for data type timestamp with timezone

Ariwibawa · Post by **Ariwibawa** » Sun 16 Aug 2009 15:49

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

Shalex · Post by **Shalex** » Wed 19 Aug 2009 16:37

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 ).