Обсуждение: Database Migration Wizard and Sequences.

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

> -----Original Message-----
> From: Brage Førland [mailto:brage@zoo.uib.no]
> Sent: 12 February 2003 14:56
> To: pgadmin-hackers@postgresql.org
> Subject: [pgadmin-hackers] Database Migration Wizard and Sequences.
>
>
> Are there any reasons why the data migration plugin always
> converts the type of the field to INT8?

Some people asked and it seemed like a good idea at the time :-)

> 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.

Yes, this caused me a *major* headache a while ago.

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

Patch applied, thanks.

> 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?

Done.

Regards, Dave.