Bug #817: Valid timezone +1300 rejected

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #817: Valid timezone +1300 rejected
Date: 2002-11-13 12:40:48
Message-ID: 20021113124048.1F5FF475FC6@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

MI (mi(at)alma(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Brian Harris 2002-11-13 12:51:11 PostgreSQL No Longer Handles Mixed Case Sequences
Previous Message Nick Howden 2002-11-13 10:31:27 Possible bug in query planner when using DISTINCT