Grzegorz =?iso-8859-2?q?Prze=BCdziecki?= <[EMAIL PROTECTED]> writes:
>> It won't work and will likely crash the backend.
> Even if I will do like this and for ever??
> 1. attnum will be unique and greater than 0
> 2. no holes in attnum numeric
> 3. Make change
> 4. restart postgresql
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.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
