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

From Greg Stark
Subject Re: change attnum in pg_catalog.pg_attribute
Date
Msg-id 87k6nhnild.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: change attnum in pg_catalog.pg_attribute  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane <tgl@sss.pgh.pa.us> writes:

> somee <grzegorz.przezdziecki@polskiesklepy.pl> writes:
> > I want to change column order in select * from table instruction;
> > I can do that changing attnum but I don't know it is safely or not for
> > system.
>
> It won't work and will likely crash the backend.

Out of curiosity, would it work if the table were completely empty at the
time?

--
greg

pgsql-general by date:

Previous
From: Grzegorz Przeździecki
Date:
Subject: Re: change attnum in pg_catalog.pg_attribute
Next
From: Carlos Roberto Chamorro Mostac
Date:
Subject: unsubscribe