X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 05B62D1E966 for ; Thu, 18 Mar 2004 15:55:53 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 98423-09 for ; Thu, 18 Mar 2004 11:55:52 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 83264D1E93F for ; Thu, 18 Mar 2004 11:55:47 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i2IFteed009458; Thu, 18 Mar 2004 10:55:40 -0500 (EST) To: Stephan Szabo Cc: Raman , pgsql-sql@postgresql.org Subject: Re: Date format issue In-reply-to: <20040317215536.I38957@megazone.bigpanda.com> References: <200403170927.50757.dev@archonet.com> <006301c40cab$1cfbee30$d4c7a8c0@raman> <20040317215536.I38957@megazone.bigpanda.com> Comments: In-reply-to Stephan Szabo message dated "Wed, 17 Mar 2004 21:58:40 -0800" Date: Thu, 18 Mar 2004 10:55:40 -0500 Message-ID: <9457.1079625340@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/194 X-Sequence-Number: 17293 Stephan Szabo writes: > You didn't say what version you're using, but IIRC, there was a bug which > caused the above sort of behavior. I think it was fixed in 7.4 and could > be fixed in 7.3.x with a catalog change which you might be able to find in > the archives. Good memory! Here's the CVS log entry: 2003-03-13 23:44 tgl * src/include/catalog/pg_proc.h (REL7_3_STABLE): Repair incorrect prorettype entry for timestamptz_izone. Can't force initdb in the 7.3 branch, but we can at least make it right for people who install 7.3.3 from scratch. It looks like UPDATE pg_proc SET prorettype = 1114 WHERE oid = 1026; would fix it, but I counsel testing that in a scratch database ... regards, tom lane