Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Timestamp Datatype Changing automatically to Timestamp without time zone
Date
Msg-id 17391.1246372160@sss.pgh.pa.us
Whole thread Raw
In response to Timestamp Datatype Changing automatically to Timestamp without time zone  (Rajdeep Das <sendrajster@gmail.com>)
List pgsql-admin
Tree view 
Rajdeep Das <sendrajster@gmail.com> writes:
> 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'.

Those are the same type.

> This change is causing my SQL to fail as TO_TIMESTAMP function is reporting
> error.

This is not what's causing your problem.  But since you gave no details,
we can't guess what your problem actually is.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Milen A. Radev"
Date:
Subject: Re: Application Transaction Question... Postgres 8.3.6 - PHP 5 - Solaris 10
Next
From: Scott Marlowe
Date:
Subject: Re: Timestamp Datatype Changing automatically to Timestamp without time zone