Re: 8.1.x (tested 8.1.8) timezone bugs - Mailing list pgsql-hackers

From Joshua D. Drake
Subject Re: 8.1.x (tested 8.1.8) timezone bugs
Date
Msg-id 45F6FB25.50505@commandprompt.com
Whole thread Raw
In response to Re: 8.1.x (tested 8.1.8) timezone bugs  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: 8.1.x (tested 8.1.8) timezone bugs  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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/



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: 8.1.x (tested 8.1.8) timezone bugs
Next
From: "Simon Riggs"
Date:
Subject: Re: Synchronized Scan update