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: BUG #4073: ERROR: invalid input syntax for type timestamp: "Sat Mar 29 04:47:06 WEST 2008"


  • From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
  • To: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
  • Cc: Pedro Alves <pedro(at)neraka(dot)no-ip(dot)org>, pgsql-bugs(at)postgresql(dot)org
  • Subject: Re: BUG #4073: ERROR: invalid input syntax for type timestamp: "Sat Mar 29 04:47:06 WEST 2008"
  • Date: Mon, 31 Mar 2008 17:41:23 -0400
  • Message-id: <24793.1206999683@sss.pgh.pa.us> <text/plain>

Heikki Linnakangas <heikki(at)enterprisedb(dot)com> writes:
> Pedro Alves wrote:
>> Since saturday Portugal is in WEST timezone.

> We don't include all timezone abbreviations, because they're generally 
> not well-defined. Not sure if that's the case with WEST, but it seems 
> quite likely. We do have the abbreviation WETDST for that, though.

Yeah, it seems to have been left out of our default list of TZ
abbreviations, probably because it seemed way too likely to be
non-unique.

			regards, tom lane



Home | Main Index | Thread Index

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