Re: change attnum in pg_catalog.pg_attribute - Mailing list pgsql-general

From Grzegorz Przeździecki
Subject Re: change attnum in pg_catalog.pg_attribute
Date
Msg-id 200504052044.24313.Grzegorz.Przezdziecki@PolskieSklepy.pl
Whole thread Raw
In response to Re: change attnum in pg_catalog.pg_attribute  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Welcome
>
> Yes, unless you also TRUNCATE the table, because attnum ordering tells
> about the physical data layout within the table rows.  Furthermore,
> altering only pg_attribute is unlikely to represent a complete update
> of the catalogs --- attnums also show up in pg_index, pg_attrdef,
> pg_depend, pg_rewrite if there are any rules or views mentioning the
> columns, and probably some other places I forgot.
>

Now  understand
Thanks a lot


>             regards, tom lane

Best Regards

--
Grzegorz Przeździecki
www.PolskieSklepy.pl
kom. +48.606.822.506
gg:3701851 skype: grzegorz.przezdziecki

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: change attnum in pg_catalog.pg_attribute
Next
From: Greg Stark
Date:
Subject: Re: change attnum in pg_catalog.pg_attribute