Re: ALTER Table

Gaetano Mendola wrote:

> Shridhar Daithankar wrote:
>
>> Alex wrote:
>>
>>> is it possible to add a column to a table at a specific place ?
>>> Reading the man pages i could not figure that out.
>>
>>
>>
>> Why do you want to add it at specific location? What does it achieve?
>
>
> I miss the same feature too, this is my reason:
> is just to keep clean your schema, I have in my revision control system
> all tables with fields grouped for tipology:
>
> CREATE TABLE a(
>
> G1 as INTEGER,
> ...
> Gn as INTEGER,
> H1 as INTEGER,
> ...
> Hm as INTEGER
> );
>
> when I add let me say Gn+1 in my RCS I have:
>
> CREATE TABLE a(
>
> G1 as INTEGER,
> ...
> Gn as INTEGER,
> Gn+1 as INTEGER,
> H1 as INTEGER,
> ...
> Hm as INTEGER
> );
>
> and will be nice to have in my fourther dumps
> the same structure, just to do a DIFF betwen two schemas
> without become crazy!

Well, if you diff two schema dumps, you will find one line added to correct
scope i.e. {} block because it belongs to same table. And anyway there is big
difference between schema diffs and database diffs. Sure you can not produce an
SQL script which would bring two databases to same state.

Only thing that can be done is to manually reordering the schema since it gives
you pretty localised view of changes due to repository.

Also check http://www.varlena.com/varlena/GeneralBits/30.html. The last bit
summerises another discussion on this.

HTH

Shridhar