Re: Timezone abbreviations - out but not in?

"Dave Page" <dpage(at)pgadmin(dot)org> writes:
> On Tue, Jun 10, 2008 at 4:37 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> [ shrug... ] The set of timezone abbrevs recognized on input is
>> user-configurable, so that situation will always be possible.

> Right, but shouldn't we always output something we know we can read
> back in (unambiguously), assuming a server with no user defined
> abbreviations?

The user can remove abbreviations as well as add them, or change them
in inconsistent ways (indeed the whole point of that feature was to
cope with the fact that the same abbrevs mean different things to
different people). I don't think you can make any useful guarantees
at all.

regards, tom lane