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-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 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 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". The

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? Ma

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 a

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 so

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 use

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 up

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

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 l

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 rec

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

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

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

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 reas

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

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

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 t

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 l

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

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 so

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

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

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 cu

[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, -- Devri