On Tue, May 18, 2010 at 8:15 PM, Brad Ediger <brad(at)bradediger(dot)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