Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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


pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group