From: | Arnold Mavromatis <A(dot)Mavromatis(at)bom(dot)gov(dot)au> |
---|---|
To: | 'Stephan Szabo' <sszabo(at)megazone(dot)bigpanda(dot)com>, pgsql-bugs(at)postgresql(dot)org |
Cc: | Lan Tran <L(dot)Tran(at)bom(dot)gov(dot)au>, "'meg(at)bom(dot)gov(dot)au'" <meg(at)bom(dot)gov(dot)au>, "'aam(at)bom(dot)gov(dot)au'" <aam(at)bom(dot)gov(dot)au> |
Subject: | Re: postgresql 7.3.2 bug on date '1901-12-13' and '1901-12 |
Date: | 2003-08-21 05:37:06 |
Message-ID: | C5F387003C39D411829E00D0B7496139E2821F@jetstream.ho.bom.gov.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-hackers |
Hi Stephan and everyone
We have tried PG 7.3.4 (the bug still presents itself)
These are the following results..
Welcome to psql 7.3.4, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit
db2=> select cast(timestamptz '1901/12/13' as date);
date
------------
1901-12-13
(1 row)
db2=> select cast(timestamptz '1901/12/14' as date);
date
------------
1901-12-13
(1 row)
db2=> select cast(timestamptz '1901/12/15' as date);
date
------------
1901-12-15
(1 row)
Compiler switches..
./configure --prefix=/adamdb/postgres/pg_admin/pgsql_7.3.4 --enable-debug
--with-pgport=5433 --without-readline --without-zlib
--enable-integer-datetimes
Everything else was left at default settings
Readline and zlib were bypassed because they are not available.
HP-UX 11.11i
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2003-08-21 06:37:22 | Re: postgresql 7.3.2 bug on date '1901-12-13' and '1901-12 |
Previous Message | Stephan Szabo | 2003-08-21 03:00:35 | FW: postgresql 7.3.2 bug on date '1901-12-13' and '190 1-1 2 (fwd) |
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2003-08-21 05:40:29 | Re: Buglist |
Previous Message | Vivek Khera | 2003-08-21 04:07:31 | Re: Buglist |