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

Re: Database Migration Wizard and Sequences.

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 (view raw or flat)
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.

pgadmin-hackers by date

Next:From: frank_lupoDate: 2003-02-12 22:53:01
Subject: form configuration pg_hba.conf
Previous:From: Brage FørlandDate: 2003-02-12 14:56:29
Subject: Database Migration Wizard and Sequences.

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