Skip site navigation (1) Skip section navigation (2)

Database Migration Wizard and Sequences.

From: Brage Førland <brage(at)zoo(dot)uib(dot)no>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: Database Migration Wizard and Sequences.
Date: 2003-02-12 14:56:29
Message-ID: 20030212155629.A38992@sisyfos.zoo.uib.no (view raw or flat)
Thread:
Lists: pgadmin-hackers
Are there any reasons why the data migration plugin always converts the type
of the field to INT8? This can be a bit annoying if there are foreign keys
of type INT4 which refers to the fields. The default behaviour in PostgreSQL
is to create new serial columns of type int4. 

I suggest you keep the type of the field, and only change it only according
to the type map.

Another small annoyance is that the plugin uses "_key" to name the
sequences. Could this be changed to "_seq" to be consistent with the SERIAL
type in PostgreSQL?

     -Brage
     

pgadmin-hackers by date

Next:From: Dave PageDate: 2003-02-12 15:06:44
Subject: Re: Database Migration Wizard and Sequences.
Previous:From: Dave PageDate: 2003-02-12 14:01:08
Subject: Re: NOT NULL-bug in data migration wizard.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group