Skip site navigation (1) Skip section navigation (2)

Re: timezones to own config file

From: Joachim Wieland <joe(at)mcknight(dot)de>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: timezones to own config file
Date: 2006-05-30 19:32:56
Message-ID: 20060530193256.GB2448@mcknight.de (view raw or flat)
Thread:
Lists: pgsql-hackers
Martijn,

On Fri, May 26, 2006 at 03:03:15PM +0200, Martijn van Oosterhout wrote:
> > I think you may be thinking of yet a separate TODO item, which is to
> > be able to use the zic timezone names in timestamptz input, viz
> > 	'2006-05-24 21:11 Americas/New_York'::timestamptz
> > But names like 'IST' or 'CDT' are not zic timezone names, they just
> > represent specific offsets from UTC.

> Well, the zic database does contain information about the
> abbreviations, so we would be able to build a list of them.

That's what i've done already  :-)

> I think the right solution is probably fix the above first (allow full zic
> timezones in timestamps) and then setup the CST/CEST/etc as a list of
> aliases users can customise...

Why do you think that full zic timezone in timestamps should be done first?
For me, both features are independent, but maybe I've missed something.

As I understand it, the time zone abbreviations are not aliases for full zic
names but only for offsets.

So if you set "Region/City" as the timezone, the offset depends on the year
(because countries have changed their timezones in the past) and whether or
not DST is or was active at that time.

On the other hand, a timezone abbreviation only means "GMT + x hours" and
nothing more. The relation between both now is that a "Region/City" timezone
changes its timezone abbreviation over the years (to reflect changes to
timezones done in the past) and during the year (to reflect changes due to
daylight saving time). And this is actually what the zic database is all
about.


Joachim

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2006-05-30 19:38:55
Subject: Re: [GENERAL] 8.1.4 - problem with PITR - .backup.done / backup.ready version of the same file at the same time.
Previous:From: Marc G. FournierDate: 2006-05-30 19:21:46
Subject: Re: anoncvs still slow

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group