Re: [SQL] Argentinian timezone change at the last moment. How to change pgsql tz db?

2008-01-02 Thread Tom Lane
"Scott Marlowe" <[EMAIL PROTECTED]> 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 thi

Re: [SQL] Argentinian timezone change at the last moment. How to change pgsql tz db?

2008-01-02 Thread Scott Marlowe
On Jan 2, 2008 2:49 PM, Joe <[EMAIL PROTECTED]> wrote: > Scott Marlowe wrote: > > I've been reading up on zic and wondering if it's a reasonable thing > > to try and update the pg tz db to include the new argentinian DST > > change. Where is the tz info stored in postgres? In the catalog? > > > T

Re: [SQL] Argentinian timezone change at the last moment. How to change pgsql tz db?

2008-01-02 Thread Joe
Scott Marlowe wrote: I've been reading up on zic and wondering if it's a reasonable thing to try and update the pg tz db to include the new argentinian DST change. Where is the tz info stored in postgres? In the catalog? Typically in /usr/share/postgresql/timezone or maybe /usr/local/share/

Re: [SQL] Argentinian timezone change at the last moment. How to change pgsql tz db?

2008-01-02 Thread Scott Marlowe
Wow! I just looked this up on the web, and all I can say is, this was a really stupid idea on the part of the govt in Argentina. It takes more than a couple days to create new timezone files and deploy them normally. I've been reading up on zic and wondering if it's a reasonable thing to try

Re: [SQL] PG is in different timezone than the OS

2008-01-02 Thread Scott Marlowe
Carrying on a convo with myself here. Looking in the timezone directory, and looking at the tz database located at ftp://elsie.nci.nih.gov/pub/ it appears the southamerica timezone data was updated 2007-12-13 at 9am or so. Looking through the file it looks like the change was made: # From Steffe

Re: [SQL] PG is in different timezone than the OS

2008-01-02 Thread Scott Marlowe
On Jan 2, 2008 12:43 PM, Fernando Hevia <[EMAIL PROTECTED]> wrote: > Hi all, > > I am not sure if this is the correct list to post this issue. Please let me > know if there is a more suitable one. > > Argentina's government has recently decreted a timezone change for the > summer (daylight's saving

[SQL] PG is in different timezone than the OS

2008-01-02 Thread Fernando Hevia
Hi all, I am not sure if this is the correct list to post this issue. Please let me know if there is a more suitable one. Argentina's government has recently decreted a timezone change for the summer (daylight's savings) where local time zone changes from GMT-3 to GMT-2. The Argentinean Summer Ti