Julius Tuskenis <julius@nsoft.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
