The following bug has been logged online:
Bug reference: 5354
Logged by: Vitali
Email address: vitali(at)lumensoftware(dot)com
PostgreSQL version: 8.1.x 8.2.x
Operating system: Windows, Linux
Description: Type timestamptz doesn't allow to store time zone
Details:
I have a table:
CREATE TABLE test (
set_dt timestamptz,
set_tm timetz
) WITH OIDS;
I do insert into this table:
INSERT INTO test(set_dt, set_tm)
VALUES('2010-01-01 10:00+02', '10:00+02')
When I select from the table, the timetz has the correct time zone, the
timestamptz has -6 as a time zone, which is my server default.