BUG #5354: Type timestamptz doesn't allow to store time zone - Mailing list pgsql-bugs

The following bug has been logged online:

Bug reference:      5354
Logged by:          Vitali
Email address:      vitali@lumensoftware.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.