Julius Tuskenis <julius@xxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
