Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 8EFF82E32C7; Fri, 4 Jan 2008 10:00:44 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 87335-09; Fri, 4 Jan 2008 10:00:39 -0400 (AST) Received: from pyxis.powervt.com.ar (host3.powervt.com.ar [200.43.63.66]) by postgresql.org (Postfix) with ESMTP id 366392E32C6; Fri, 4 Jan 2008 10:00:38 -0400 (AST) Received: from pcfhevia ([201.216.249.98]) by pyxis.powervt.com.ar (IPGroup Mail Server) with ESMTP id 1OT48953; Fri, 04 Jan 2008 11:00:37 -0300 From: "Fernando Hevia" To: "'Tom Lane'" Cc: "'Scott Marlowe'" , "'Joe'" , "'SQL Postgresql List'" , Subject: Re: [SQL] Argentinian timezone change at the last moment. How to change pgsql tz db? Date: Fri, 4 Jan 2008 12:01:43 -0200 Organization: IP-TEL Message-ID: <01ea01c84eda$56631430$8f01010a@iptel.com.ar> MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 In-Reply-To: <28319.1199421476@sss.pgh.pa.us> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198 Thread-Index: AchOi5i8XTenQtBVQ2acVhuopu9GuwATi/7Q X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/87 X-Sequence-Number: 126297 > Tom Lane [mailto:tgl@sss.pgh.pa.us] wrote: > > "Fernando Hevia" writes: > > With 8.2.x the ARST abbreviation was recognized after including the > > following line in /usr/share/postgresql/8.2/timezonesets/Default > > > ARST -14400 D # Argentina Summer Time > > Um ... is that really offsetting in the correct direction? What I put > into CVS was > > ARST -7200 D # Argentina Summer Time > > If that's wrong I need to know ... > No, you are right: -7200 is the correct offset. Regards, Fernando.