[BUGS] postgresql 7.3.2 bug on date '1901-12-13' and '1901-12-13' - PK violation

2003-08-19 Thread Arnold Mavromatis
Title: Message   Hi       Your name   : Arnold Mavromatis Your email address  : [EMAIL PROTECTED]   System Configuration - PostgreSQL info Server version PostgreSQL 7.3.2 on hppa2.0w-hp-hpux11.11    Engine Version     7.3.2

FW: [BUGS] postgresql 7.3.2 bug on date '1901-12-13' and '1901-12-13'

2003-08-19 Thread Arnold Mavromatis
Thanks in advance... Cheers Arn -Original Message- From: Stephan Szabo [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2003 4:08 PM To: Arnold Mavromatis Cc: [EMAIL PROTECTED]; Lan Tran Subject: Re: [BUGS] postgresql 7.3.2 bug on date '1901-12-13' and '1901-12-13

Re: [BUGS] postgresql 7.3.2 bug on date '1901-12-13' and '1901-12

2003-08-19 Thread Arnold Mavromatis
Hi again We've actually determined that we didn't compile it but just downloaded a binary from the web...(for HP-UX 11.11) so I've got no idea as to compiler settings used on this binary... Cheers Arn -Original Message----- From: Arnold Mavromatis [mailto:[EMAIL P

Re: [BUGS] postgresql 7.3.2 bug on date '1901-12-13' and '1901-12

2003-08-20 Thread Arnold Mavromatis
Hi all [22] % pg_config --configure '--prefix=/adamdb/postgres/pg_admin/pgsql' '--without-readline' '--without-zlib' '--enable-debug' [23] % Cheers Arn -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Thursday, August 21, 2003 4

Re: [BUGS] postgresql 7.3.2 bug on date '1901-12-13' and '1901-12

2003-08-20 Thread Arnold Mavromatis
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 command

Re: [BUGS] TimeZone bug again.....

2003-12-10 Thread Arnold Mavromatis
Title: RE: [BUGS] TimeZone bug again. Operating system is redhat 9 Postgres is 7.3.2 binary rpm for linux Hi It seems that because to_timestamp does a time-zone conversion it is upsetting are attempt to load legitimate data... Is it possible (similar to the to_date fix that was

Re: [BUGS] TimeZone bug again.....

2003-12-11 Thread Arnold Mavromatis
Title: Message [Arnold Mavromatis]       Operating system is redhat 9 Postgres is 7.3.2 binary rpm for linux Hi It seems that because to_timestamp does a time-zone conversion it is upsetting are attempt to load legitimate data... Is it possible (similar to the