Re: what is the origin of postgreSQL time

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Julius Tuskenis <julius(at)nsoft(dot)lt>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: what is the origin of postgreSQL time
Date: 2008-03-31 15:47:26
Message-ID: 28589.1206978446@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Julius Tuskenis <julius(at)nsoft(dot)lt> writes:
> I've noticed that statement SELECT current_timestamp AT TIME ZONE
> 'Europe/Vilnius' returns me an error:
> ERROR: time zone "Europe/Vilnius" not recognized
> SQL state: 22023
> Time zone Europe/Vilnius is the systems timezone. I checked in
> pgsql/share/timezone the file is in there. What could be wrong?

Huh, works for me. Maybe there is something wrong with the file
permissions on the Europe/Vilnius file or one of the containing
directories? If the PG server process can't get at that file
you'd get an error like this.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Thomas Bräutigam 2008-04-01 09:25:09 Postgres and SUN
Previous Message Julius Tuskenis 2008-03-31 15:39:58 Re: what is the origin of postgreSQL time