Rajdeep Das <sendrajster(at)gmail(dot)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