From: Tom Lane <tgl@sss.pgh.pa.us>
To: Fernando Hevia <fhevia@ip-tel.com.ar>
Cc: 'Scott Marlowe' <scott.marlowe@gmail.com>
Cc: 'Joe' <dev@freedomcircle.net>
Cc: 'SQL Postgresql List' <pgsql-sql@postgresql.org>
Cc: pgsql-general@postgresql.org
Subject: Re: [SQL] Argentinian timezone change at the last moment. How to change pgsql tz db?
Date: Thu, 03 Jan 2008 23:37:56 -0500
Message-ID: <28319.1199421476@sss.pgh.pa.us> (raw)
In-Reply-To: <01dc01c84e85$e2abb5a0$8f01010a@iptel.com.ar>
References: <01dc01c84e85$e2abb5a0$8f01010a@iptel.com.ar>
"Fernando Hevia" <fhevia@ip-tel.com.ar> 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 ...
> I wonder if pg_timezone_names plays any role in the ARST issue. It does
> contain the right data (appeared after copying tzdata into
> /usr/share/postgresql/timezone and restarting server) but ARST wasn't
> accepted till previous step was done.
Too tired to experiment, but you may need a "pg_ctl reload" or even a
restart to get PG to notice changes in your timezonesets file.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, fhevia@ip-tel.com.ar, scott.marlowe@gmail.com, dev@freedomcircle.net, pgsql-general@postgresql.org
Subject: Re: [SQL] Argentinian timezone change at the last moment. How to change pgsql tz db?
In-Reply-To: <28319.1199421476@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox