Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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
- References:
- what is the origin of postgreSQL time
- From: Julius Tuskenis
- Re: what is the origin of postgreSQL time
- From: Tom Lane
- Re: what is the origin of postgreSQL time
- From: Julius Tuskenis
- what is the origin of postgreSQL time
- Prev by Date: Re: what is the origin of postgreSQL time
- Previous by thread: Re: what is the origin of postgreSQL time
- Next by thread: log_min_duration_statement log parsing
- Indexes: