Postgres Pro
Downloads
Home   >   mailing lists

Timestamp Datatype Changing automatically to Timestamp without time zone - Mailing list pgsql-admin

From Rajdeep Das
Subject Timestamp Datatype Changing automatically to Timestamp without time zone
Date
Msg-id 66ab29920906300013u5ed1b659nbbfc8594913f23c6@mail.gmail.com
Whole thread Raw
Responses Re: Timestamp Datatype Changing automatically to Timestamp without time zone  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Timestamp Datatype Changing automatically to Timestamp without time zone  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-admin
Tree view
Dear Sir/Madam,

This is important and I need your help here. 

I have taken a dump of my database from the old version of pg viz.8.1, using pg_dump command. In the db I have a table with a column of datatype 'timestamp'. Now, when I try to restore it on the new pg version 8.3, the datatype of the column is getting altered to 'timestamp with no time zone'. This change is causing my SQL to fail as TO_TIMESTAMP function is reporting error.

Please suggest me the cause of this automatic datatype change. Also, tell me how to make my TO_TIMESTAMP and other data functions work.

Thank You
Rajdeep

pgsql-admin by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Fwd: large cache
Next
From: Carol Walter
Date:
Subject: Application Transaction Question... Postgres 8.3.6 - PHP 5 - Solaris 10