Postgres Pro
Downloads
Home   >   mailing lists

Thread: Migration from 7.2.3 to 7.3.2 ( missing datetime data type )

Migration from 7.2.3 to 7.3.2 ( missing datetime data type )

From
Aleksey Serba
Date:
        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

Re: Migration from 7.2.3 to 7.3.2 ( missing datetime data type )

From
Tom Lane
Date:
Aleksey Serba <aleksey@caj.spb.ru> writes:
> 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!

CREATE DOMAIN datetime AS timestamp with time zone;

In the long run you should probably migrate to the SQL-standard datatype
name, but the DOMAIN trick will be useful in the meanwhile.

            regards, tom lane

Re: Migration from 7.2.3 to 7.3.2 ( missing datetime data type )

From
Aleksey Serba
Date:
>> 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!

TL> CREATE DOMAIN datetime AS timestamp with time zone;

TL> In the long run you should probably migrate to the SQL-standard datatype
TL> name, but the DOMAIN trick will be useful in the meanwhile.
TL>                         regards, tom lane

    Tom,

    Thank you very much!

    Regards,
        Aleksey