Re: Does changing attribute order breaks something?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: geohas <lists(at)hasibether(dot)at>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Does changing attribute order breaks something?
Date: 2014-06-30 17:32:42
Message-ID: 12662.1404149562@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

geohas <lists(at)hasibether(dot)at> writes:
> Are there any known issues when changing the attnums?

> airport=# update pg_attribute set attnum = 3 where attname = 'abc' and
> attrelid = 18328;
> UPDATE 1
> airport=# update pg_attribute set attnum = 2 where attname = 'foo' and
> attrelid = 18328;
> UPDATE 1

I assume you quickly found out that that totally broke your table,
so why are you asking?

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2014-06-30 17:44:47 Re: better atomics - v0.5
Previous Message Andres Freund 2014-06-30 17:22:59 Re: Spinlocks and compiler/memory barriers