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

2008-01-04 Thread Fernando Hevia
Tom Lane [mailto:[EMAIL PROTECTED] wrote: Fernando Hevia [EMAIL PROTECTED] 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

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

2008-01-03 Thread Fernando Hevia
Tom Lane wrote: 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

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

2008-01-03 Thread Fernando Hevia
Tom Lane [mailto:[EMAIL PROTECTED] wrote: 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

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

2008-01-03 Thread Tom Lane
Fernando Hevia [EMAIL PROTECTED] 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

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] 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

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? Typically in

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 this.