support for data type timestamp with timezone

support for data type timestamp with timezone

Postby 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
Ariwibawa
 
Posts: 12
Joined: Sun 16 Aug 2009 14:18
Location: Indonesia

Postby 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 ).
Shalex
Devart Team
 
Posts: 7654
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for PostgreSQL