Re: Timezone abbreviations - out but not in?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Dave Page" <dpage(at)pgadmin(dot)org>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Timezone abbreviations - out but not in?
Date: 2008-06-10 15:37:12
Message-ID: 18212.1213112232@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Dave Page" <dpage(at)pgadmin(dot)org> writes:
> It seems like a bug that we happily output PKST as a timezone (in a
> 'timestamp with time zone'), but won't accept it back in.

[ shrug... ] The set of timezone abbrevs recognized on input is
user-configurable, so that situation will always be possible.

It appears though that our tznames list is a bit out of date: it
has PKT but not PKST or PKDT, which evidently are the current spellings
in use for that zone. It might be time for someone to go through
the zic database again to see what else has changed.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dave Page 2008-06-10 15:46:16 Re: Timezone abbreviations - out but not in?
Previous Message Josh Berkus 2008-06-10 15:34:51 Re: pg_statistics and sample size WAS: Overhauling GUCS