Re: Change order of table-columns in pg_catalog.pg_attribute.attnum

More important question would be, why would you want to do this (change columns order)?
I can't think of any valid reason for this.

Igor Neyman

-----Original Message-----
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Erwin Brandstetter
Sent: Wednesday, June 06, 2007 11:22 AM
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Change order of table-columns in pg_catalog.pg_attribute.attnum

On Jun 6, 4:59 pm, t...@sss.pgh.pa.us (Tom Lane) wrote:
> Alvaro Herrera <alvhe...@commandprompt.com> writes:
> > Erwin Brandstetter escribió:
> >> If I want to change the default order of two columns of a table,
> >> can I just manipulate the values in pg_catalog.pg_attribute.attnum?
> > It works -- as long as the table is empty.
>
> And as long as you have no views, foreign keys, indexes, defaults,
> rules, etc etc etc referencing the columns.
>
> Short answer is don't even think of trying it.

Thanks for your answers.
I had tried it with data in the table and it seemed to work, but it does mess up views referencing the table. So, no
go.

The only way to change the default order of columns is still to drop the table and all references to it and recreate it
all?


Regards
Erwin


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@postgresql.org so that your
       message can get through to the mailing list cleanly