Re: ERROR: unrecognized time zone name: "UTC" - Mailing list pgsql-general

From Brad Ediger
Subject Re: ERROR: unrecognized time zone name: "UTC"
Date
Msg-id AANLkTikJJJ5TCfnqESzR0KqNCbJJ3MNvZcuqZybK3Now@mail.gmail.com
Whole thread Raw
In response to ERROR: unrecognized time zone name: "UTC"  (Brad Ediger <brad@bradediger.com>)
List pgsql-general
On Tue, May 18, 2010 at 8:15 PM, Brad Ediger <brad@bradediger.com> wrote:
> I am experiencing this error trying to set the connection time zone to
> UTC on PostgreSQL 8.4.4:
>
>    postgres=# set time zone 'UTC';
>    ERROR:  unrecognized time zone name: "UTC"

Answered my own question -- it was my Prefix Portage install missing
the zoneinfo database ($EPREFIX/usr/share/zoneinfo/UTC). Working great
now.

-be

pgsql-general by date:

Previous
From: Dennis Gearon
Date:
Subject: Re: use of IN() with literals
Next
From: Joshua Tolley
Date:
Subject: Re: Connection lost