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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

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: Mon, 31 Mar 2008 11:47:26 -0400
  • Message-id: <28589.1206978446@sss.pgh.pa.us> <text/plain>

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



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group