From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | Brage Førland <brage(at)zoo(dot)uib(dot)no>, <pgadmin-hackers(at)postgresql(dot)org> |
Subject: | Re: Database Migration Wizard and Sequences. |
Date: | 2003-02-12 15:06:44 |
Message-ID: | 03AF4E498C591348A42FC93DEA9661B8259C4C@mail.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
> -----Original Message-----
> From: Brage Førland [mailto:brage(at)zoo(dot)uib(dot)no]
> Sent: 12 February 2003 14:56
> To: pgadmin-hackers(at)postgresql(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | frank_lupo | 2003-02-12 22:53:01 | form configuration pg_hba.conf |
Previous Message | Brage Førland | 2003-02-12 14:56:29 | Database Migration Wizard and Sequences. |