Re: 8.1.x (tested 8.1.8) timezone bugs

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: 8.1.x (tested 8.1.8) timezone bugs
Date: 2007-03-13 19:27:33
Message-ID: 45F6FB25.50505@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> AFAICS there is not any provision in the code that reads that string to
> have different rules in different years, so you're more or less stuck
> with being wrong before 2007 or being wrong after. Realistically this
> means that POSIX-style rule strings are no longer useful, and you'd
> better start using one of the zic timezone names. Which, prior to 8.2,
> means you'd better spell PST8PDT in upper case ... or maybe insert a
> symlink in the timezone/ tree to make the lower-case name valid ...

O.k., really trying to not be difficult here but... if we modified 8.1.9
(to be released) to not fold the case of the unquoted timezone, doesn't
that resolve the issue entirely? (well it is a band-aid but still).

Joshua D. Drake

>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-03-13 19:38:32 Re: 8.1.x (tested 8.1.8) timezone bugs
Previous Message Simon Riggs 2007-03-13 19:24:46 Re: Synchronized Scan update