The following bug has been logged online:
Bug reference: 5714
Logged by: Alexander Loechel
Email address: Alexander.Loechel@unibw.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().