| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| Attachment | Content-Type | Size |
|---|---|---|
| frmWizard.frm.diff3 | text/plain | 855 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2003-02-12 15:06:44 | Re: Database Migration Wizard and Sequences. |
| Previous Message | Dave Page | 2003-02-12 14:01:08 | Re: NOT NULL-bug in data migration wizard. |