BUG #5354: Type timestamptz doesn't allow to store time zone

Поиск
Список
Период
Сортировка
От Vitali
Тема BUG #5354: Type timestamptz doesn't allow to store time zone
Дата
Msg-id 201003011552.o21Fqg3e029063@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #5354: Type timestamptz doesn't allow to store time zone
Список 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.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "Andy Lester"
Дата:
Сообщение: BUG #5355: locale incorrectly comma-separates "(null)"
Следующее
От: "Michael Gould"
Дата:
Сообщение: BUG #5356: citext not acting like case insensitive search