Re: change attnum in pg_catalog.pg_attribute

From: Grzegorz Przeździecki <Grzegorz(dot)Przezdziecki(at)PolskieSklepy(dot)pl>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: somee(at)poczta(dot)onet(dot)pl, pgsql-general(at)postgresql(dot)org
Subject: Re: change attnum in pg_catalog.pg_attribute
Date: 2005-04-05 18:26:51
Message-ID: 200504052026.51703.Grzegorz.Przezdziecki@PolskieSklepy.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dnia wtorek, 5 kwietnia 2005 20:13, Tom Lane napisał:
> 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.
>

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

> regards, tom lane

Best Regards

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Rysdam 2005-04-05 18:29:55 Re: Check for existence of index
Previous Message Tom Lane 2005-04-05 18:19:55 Re: Check for existence of index