Re: what is the origin of postgreSQL time

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

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