BUG #5714: TZ pattern error on to_timestamp

From: "Alexander Loechel" <Alexander(dot)Loechel(at)unibw(dot)de>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5714: TZ pattern error on to_timestamp
Date: 2010-10-17 11:49:45
Message-ID: 201010171149.o9HBnjH6011355@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 5714
Logged by: Alexander Loechel
Email address: Alexander(dot)Loechel(at)unibw(dot)de
PostgreSQL version: 8.4.5
Operating system: Ubuntu Server 10.04. LTS
Description: TZ pattern error on to_timestamp
Details:

After an update on my ubuntu system of postgres 8.4.4 to 8.4.5 the
to_timestamp methode produces different results.

in a CREAT View statement I have following methode call:
>>to_timestamp(dbtimestamp, 'YYYY/MM/DD HH24:MI:SS TZ') AS "timestamp"<<

Where dbtimestamp is a String coming from a CMS.

before migration it produces normal timestamps
after migration I get following Message:

"ERROR: TZ/tz format patterns are not supported in to_date"

I guess this behaviour is not intended as chapter 9.9 of the manual allows a
TZ pattern on to_timestamp().

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2010-10-17 15:10:09 Re: BUG #5714: TZ pattern error on to_timestamp
Previous Message Alvaro Herrera 2010-10-17 03:18:24 Re: BUG #5713: lo_export