support for data type timestamp with timezone

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
Posts: 12
Joined: Sun 16 Aug 2009 14:18
Location: Indonesia

support for data type timestamp with timezone

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,

nb:sorry for my bad english

Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

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

Post Reply