Received: from localhost (unknown [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id DFB8B2E3338
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu,  3 Jan 2008 08:27:04 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024)
	with ESMTP id 48266-06 for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu,  3 Jan 2008 08:27:01 -0400 (AST)
Received: from pyxis.powervt.com.ar (host3.powervt.com.ar [200.43.63.66])
	by postgresql.org (Postfix) with ESMTP id B01192E31A7
	for <pgsql-sql@postgresql.org>; Thu,  3 Jan 2008 08:27:01 -0400 (AST)
Received: from pcfhevia ([201.216.249.98])
	by pyxis.powervt.com.ar (IPGroup Mail Server) with ESMTP id 1OT48953;
	Thu, 03 Jan 2008 09:26:59 -0300
From: "Fernando Hevia" <fhevia@ip-tel.com.ar>
To: "'Tom Lane'" <tgl@sss.pgh.pa.us>,
	"'Scott Marlowe'" <scott.marlowe@gmail.com>
Cc: "'Joe'" <dev@freedomcircle.net>,
	"'SQL Postgresql List'" <pgsql-sql@postgresql.org>
Subject: Re: Argentinian timezone change at the last moment. How to change
	pgsql tz db?
Date: Thu, 3 Jan 2008 10:27:14 -0200
Organization: IP-TEL
Message-ID: <014801c84e03$f8ca8730$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: <24363.1199317514@sss.pgh.pa.us>
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
Thread-Index: AchNmYxYcNz2Jm7uSB2OGUJBDNqnoAAZ6JzQ
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200801/15
X-Sequence-Number: 29869



> Tom Lane wrote:
> 
> "Scott Marlowe" <scott.marlowe@gmail.com> writes:
> > That doesn't get me what I need.  It lets me change the alias of
> > timezones, but not the start and stop of daylight savings time.  I
> > think for that I'd have to edit / replace the files in
> > postgresql-8.2.x/src/timezone/data/ and recompile to fix this.
> 
> Since the OP has apparently already managed to get updated tzdata files
> installed on his system, he could just copy them into
> /usr/share/postgresql/timezone --- anything using zic should be a
> compatible file format.
> 
> The lack-of-ARST-on-input problem can be addressed by mucking with
> /usr/share/postgresql/timezonesets/Default, if you're using 8.2.
> In earlier versions the table is hardwired into datetime.c :-(
> 
> 			regards, tom lane

Thanks Scott and Tom for your help on this.

After copying the updated tz file to /usr/share/postgresql/timezone Postgres
got aware of the time change.

Regarding the ARST recognition, I'm still on 8.1.9. :(
An upgrade seems urgent now.

Regards,
Fernando.