Rajdeep Das <sendrajster@xxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
