Re: Timezone view - Mailing list pgsql-hackers

From Martijn van Oosterhout
Subject Re: Timezone view
Date
Msg-id 20080221142323.GB9174@svana.org
Whole thread Raw
In response to Re: Timezone view  (Naz Gassiep <naz@mira.net>)
List pgsql-hackers
On Wed, Feb 20, 2008 at 11:43:43PM +0700, Naz Gassiep wrote:
> Not true, the zone.tab file has 398 zones defined, and in my PG 8.2
> running on Debian, there are 564 timezones listed in pg_timezone_names.
> The field I propose would indicate which 398 of those 564 are listed in
> zone.tab as those are the actual Olsen defined timezones, the rest are
> aliases.

The zone.tab doesn't have all the zones. Try:

find /usr/share/zoneinfo/ -name posix -prune -o -name right -prune -o -type f |wc -l

Gives 577 on my system.

Not sure if the zone.tab is even used.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
>  -- John F Kennedy

pgsql-hackers by date:

Previous
From: Alexey Klyukin
Date:
Subject: Re: Permanent settings
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Permanent settings