Re: [HACKERS] New tzdata available

2007-11-09 Thread Zdenek Kotala
Tom Lane wrote: Magnus Hagander [EMAIL PROTECTED] writes: On Fri, 2007-11-09 at 02:26 -0500, Tom Lane wrote: Plan B would be to take out contracts on all the banana-republic politicians who think that changing DST laws with a month's notice is a pleasant pastime. I fear we lack the resources

Re: [HACKERS] New tzdata available

2007-11-09 Thread Magnus Hagander
On Fri, 2007-11-09 at 02:56 -0500, Tom Lane wrote: Magnus Hagander [EMAIL PROTECTED] writes: On Fri, 2007-11-09 at 02:26 -0500, Tom Lane wrote: Plan B would be to take out contracts on all the banana-republic politicians who think that changing DST laws with a month's notice is a

Re: [HACKERS] New tzdata available

2007-11-09 Thread Gregory Stark
Magnus Hagander [EMAIL PROTECTED] writes: On Fri, 2007-11-09 at 02:56 -0500, Tom Lane wrote: Be fair --- the USA did give us a couple years' notice. Not for the latest changes, IIRC. It didn't match my recollection either. But apparently Tom is almost right. The Energy Policy Act of 2005

Re: [HACKERS] New tzdata available

2007-11-09 Thread Magnus Hagander
On Fri, 2007-11-09 at 10:04 +, Gregory Stark wrote: Magnus Hagander [EMAIL PROTECTED] writes: On Fri, 2007-11-09 at 02:56 -0500, Tom Lane wrote: Be fair --- the USA did give us a couple years' notice. Not for the latest changes, IIRC. It didn't match my recollection either.

Re: [HACKERS] New tzdata available

2007-11-09 Thread Alvaro Herrera
Magnus Hagander wrote: Tom Lane wrote: Alvaro Herrera [EMAIL PROTECTED] writes: Zdenek Kotala wrote: I think we need some different mechanism how to deliver timezone updated. Even when the system TZ is not used, we could deliver our zic executable (pgzic?) and let the user drop the

Re: [HACKERS] New tzdata available

2007-11-09 Thread Magnus Hagander
On Fri, 2007-11-09 at 09:25 -0300, Alvaro Herrera wrote: Magnus Hagander wrote: Tom Lane wrote: Alvaro Herrera [EMAIL PROTECTED] writes: Zdenek Kotala wrote: I think we need some different mechanism how to deliver timezone updated. Even when the system TZ is not used, we

Re: [HACKERS] New tzdata available

2007-11-09 Thread Zdenek Kotala
Alvaro Herrera wrote: I think the first step is to install the zic binary along the rest of the stuff, so that a user without the source tree can compile the tzdata package. Unless the compiled representation is portable, which I kinda doubt? Maybe wild idea, what's about use buildfarm to

Re: [HACKERS] New tzdata available

2007-11-09 Thread Zdenek Kotala
Magnus Hagander wrote: On Fri, 2007-11-09 at 09:25 -0300, Alvaro Herrera wrote: Magnus Hagander wrote: Tom Lane wrote: Alvaro Herrera [EMAIL PROTECTED] writes: Zdenek Kotala wrote: I think we need some different mechanism how to deliver timezone updated. Even when the system TZ is not

Re: [HACKERS] New tzdata available

2007-11-09 Thread Magnus Hagander
On Fri, 2007-11-09 at 14:23 +0100, Zdenek Kotala wrote: Magnus Hagander wrote: On Fri, 2007-11-09 at 09:25 -0300, Alvaro Herrera wrote: Magnus Hagander wrote: Tom Lane wrote: Alvaro Herrera [EMAIL PROTECTED] writes: Zdenek Kotala wrote: I think we need some different mechanism how to

Re: [HACKERS] New tzdata available

2007-11-09 Thread Andrew Dunstan
Zdenek Kotala wrote: Alvaro Herrera wrote: I think the first step is to install the zic binary along the rest of the stuff, so that a user without the source tree can compile the tzdata package. Unless the compiled representation is portable, which I kinda doubt? Maybe wild idea, what's

Re: [HACKERS] New tzdata available

2007-11-09 Thread Zdenek Kotala
Andrew Dunstan wrote: Zdenek Kotala wrote: Alvaro Herrera wrote: I think the first step is to install the zic binary along the rest of the stuff, so that a user without the source tree can compile the tzdata package. Unless the compiled representation is portable, which I kinda doubt?

Re: [HACKERS] New tzdata available

2007-11-09 Thread Tom Lane
Zdenek Kotala [EMAIL PROTECTED] writes: Another interesting questions are what postgres does when timezone files are changed? Does it need SIGHUP to invoke rereading? What is impact on current running transaction when tz file is changed? This falls into the category of get a life. There is

Re: [HACKERS] New tzdata available

2007-11-09 Thread Tom Lane
Alvaro Herrera [EMAIL PROTECTED] writes: I think the first step is to install the zic binary along the rest of the stuff, so that a user without the source tree can compile the tzdata package. Unless the compiled representation is portable, which I kinda doubt? Actually, it is. In fact,

Re: [HACKERS] New tzdata available

2007-11-09 Thread Zdenek Kotala
Tom Lane wrote: Alvaro Herrera [EMAIL PROTECTED] writes: I think the first step is to install the zic binary along the rest of the stuff, so that a user without the source tree can compile the tzdata package. Unless the compiled representation is portable, which I kinda doubt? Actually, it

Re: [HACKERS] New tzdata available

2007-11-09 Thread Alvaro Herrera
Tom Lane wrote: Alvaro Herrera [EMAIL PROTECTED] writes: I think the first step is to install the zic binary along the rest of the stuff, so that a user without the source tree can compile the tzdata package. Unless the compiled representation is portable, which I kinda doubt?

Re: [HACKERS] New tzdata available

2007-11-08 Thread Zdenek Kotala
Devrim GÜNDÜZ napsal(a): Hi, ftp://elsie.nci.nih.gov/pub/tzdata2007i.tar.gz Per announcement: ...is now available; this reflects changes for Cuba and Syria circulated earlier this week on the time zone mailing list. There are no code changes, so there's no tzcode2007i; tzcood2007h remains

Re: [HACKERS] New tzdata available

2007-11-08 Thread Tom Lane
Alvaro Herrera [EMAIL PROTECTED] writes: Zdenek Kotala wrote: I think we need some different mechanism how to deliver timezone updated. Even when the system TZ is not used, we could deliver our zic executable (pgzic?) and let the user drop the latest tzdata somewhere and recompile it.

Re: [HACKERS] New tzdata available

2007-11-08 Thread Alvaro Herrera
Zdenek Kotala wrote: Devrim GÜNDÜZ napsal(a): Hi, ftp://elsie.nci.nih.gov/pub/tzdata2007i.tar.gz Per announcement: ...is now available; this reflects changes for Cuba and Syria circulated earlier this week on the time zone mailing list. There are no code changes, so there's no tzcode2007i;

Re: [HACKERS] New tzdata available

2007-11-08 Thread Magnus Hagander
Andrew Dunstan wrote: Tom Lane wrote: Are Windows users accustomed to having up-to-the-minute timezone information? Maybe there's something I don't know about Microsoft's update practices, but I would have thought that the expectations on that platform would be pretty darn low.

Re: [HACKERS] New tzdata available

2007-11-08 Thread Andrew Dunstan
Tom Lane wrote: Are Windows users accustomed to having up-to-the-minute timezone information? Maybe there's something I don't know about Microsoft's update practices, but I would have thought that the expectations on that platform would be pretty darn low. No, they push updates fairly

Re: [HACKERS] New tzdata available

2007-11-08 Thread Magnus Hagander
Tom Lane wrote: Alvaro Herrera [EMAIL PROTECTED] writes: Zdenek Kotala wrote: I think we need some different mechanism how to deliver timezone updated. Even when the system TZ is not used, we could deliver our zic executable (pgzic?) and let the user drop the latest tzdata somewhere and

Re: [HACKERS] New tzdata available

2007-11-08 Thread Trevor Talbot
On 11/8/07, Magnus Hagander [EMAIL PROTECTED] wrote: Andrew Dunstan wrote: Tom Lane wrote: Are Windows users accustomed to having up-to-the-minute timezone information? Maybe there's something I don't know about Microsoft's update practices, but I would have thought that the

Re: [HACKERS] New tzdata available

2007-11-08 Thread Tom Lane
Magnus Hagander [EMAIL PROTECTED] writes: Tom Lane wrote: For people using prebuilt packages, it's really the packager's problem. I think most packagers are going to move to depending on a system timezone DB if at all possible. Still need a solution for those where it's not possible (hint:

Re: [HACKERS] New tzdata available

2007-11-08 Thread Magnus Hagander
On Thu, Nov 08, 2007 at 05:46:08PM -0800, Trevor Talbot wrote: On 11/8/07, Magnus Hagander [EMAIL PROTECTED] wrote: Andrew Dunstan wrote: Tom Lane wrote: Are Windows users accustomed to having up-to-the-minute timezone information? Maybe there's something I don't know about

Re: [HACKERS] New tzdata available

2007-11-08 Thread Tom Lane
Magnus Hagander [EMAIL PROTECTED] writes: On Thu, Nov 08, 2007 at 05:46:08PM -0800, Trevor Talbot wrote: I've been wondering lately why it isn't just stored in the database somewhere. That's a different question. One reason is that we wanted files compatible with the stuff that was included

Re: [HACKERS] New tzdata available

2007-11-08 Thread Magnus Hagander
On Fri, 2007-11-09 at 02:26 -0500, Tom Lane wrote: Magnus Hagander [EMAIL PROTECTED] writes: On Thu, Nov 08, 2007 at 05:46:08PM -0800, Trevor Talbot wrote: I've been wondering lately why it isn't just stored in the database somewhere. That's a different question. One reason is that we

Re: [HACKERS] New tzdata available

2007-11-08 Thread Tom Lane
Magnus Hagander [EMAIL PROTECTED] writes: On Fri, 2007-11-09 at 02:26 -0500, Tom Lane wrote: Plan B would be to take out contracts on all the banana-republic politicians who think that changing DST laws with a month's notice is a pleasant pastime. I fear we lack the resources for that,

[HACKERS] New tzdata available

2007-11-07 Thread Devrim GÜNDÜZ
Hi, ftp://elsie.nci.nih.gov/pub/tzdata2007i.tar.gz Per announcement: ...is now available; this reflects changes for Cuba and Syria circulated earlier this week on the time zone mailing list. There are no code changes, so there's no tzcode2007i; tzcood2007h remains current. Regards, -- Devrim