Re: change attnum in pg_catalog.pg_attribute

From: Greg Stark <gsstark(at)mit(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: change attnum in pg_catalog.pg_attribute
Date: 2005-04-05 19:12:30
Message-ID: 87k6nhnild.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

> somee <grzegorz(dot)przezdziecki(at)polskiesklepy(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Carlos Roberto Chamorro Mostac 2005-04-05 20:20:59 unsubscribe
Previous Message Grzegorz Przeździecki 2005-04-05 18:44:24 Re: change attnum in pg_catalog.pg_attribute