Migration from 7.2.3 to 7.3.2 ( missing datetime data type )

From: Aleksey Serba <aleksey(at)caj(dot)spb(dot)ru>
To: pgsql-general(at)postgresql(dot)org
Subject: Migration from 7.2.3 to 7.3.2 ( missing datetime data type )
Date: 2003-03-12 07:54:30
Message-ID: 2500639.20030312105430@caj.spb.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi guys!

I'm trying to migrate project working with pgsql-7.2.3 to pgsql-7.3.2.
I've found some troubles. The main is, i have type datetime almost in
all tables from database. Thus, i've got error when trying create
table with such date type. ( And restoring database dump failed ).
The question is:
What the easy way to restore database?
How i can define alias for data type? It would be terrific!

Of course, the last way - for each table create duplicate table
( instead of datetime use timestamp ) and fill it using 'INSERT FROM SELECT' query.
Afterwards, dump the specified tables and restore it in new data schema.
But it's so boring...

Any help would be greatly appreciated.

Thanks in advance,

Aleksey

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Csaba Nagy 2003-03-12 09:15:24 Re: TO ADMIN: E-mail change
Previous Message Mohd Ghalib Akhtar 2003-03-12 06:43:19 socket error