Re: i have table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: i have table
Date: 2006-10-05 13:31:43
Message-ID: 12317.1160055103@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> writes:
> Alright, you could play with something like:

> UPDATE pg_attribute SET attnum = <your number of ordering> where
> attrelid=<your tableoid> and attname='<your column name>';

That's guaranteed to break his table, because the physical storage
of the rows won't have changed. (To name only the most obvious
problem...)

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Achilleas Mantzios 2006-10-05 15:15:54 Re: i have table
Previous Message Achilleas Mantzios 2006-10-05 07:32:55 Re: i have table