Bug #817: Valid timezone +1300 rejected

Поиск
Список
Период
Сортировка
От pgsql-bugs@postgresql.org
Тема Bug #817: Valid timezone +1300 rejected
Дата
Msg-id 20021113124048.1F5FF475FC6@postgresql.org
обсуждение исходный текст
Ответы Re: Bug #817: Valid timezone +1300 rejected  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
MI (mi@alma.ch) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
Valid timezone +1300 rejected

Long Description
New Zealand Daylight Savings Time time zone is "+1300" (and others as well, I think). Silly, I agree, but that's how it
is.
Postgresql 7.2.2 rejects it as "Bad timestamp external representation".

Sample Code
pms=> create table test (t timestamp);
CREATE
pms=> insert into test values ('Tue, 12 Nov 2002 08:22:37 +0100');
INSERT 71853 1
pms=> insert into test values ('Tue, 12 Nov 2002 08:22:37 +1300');
ERROR:  Bad timestamp external representation 'Tue, 12 Nov 2002 08:22:37 +1300'

No file was uploaded with this report

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

Предыдущее
От: pgsql-bugs@postgresql.org
Дата:
Сообщение: Bug #816: Bad time conversion from type abstime to datetime
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Bug #816: Bad time conversion from type abstime to datetime