Skip site navigation (1) Skip section navigation (2)

Re: change natural column order

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: Joolz <joolz(at)arbodienst-limburg(dot)nl>,pgsql-general(at)postgresql(dot)org, Tino Wildenhain <tino(at)wildenhain(dot)de>
Subject: Re: change natural column order
Date: 2004-11-30 16:08:59
Message-ID: 20794.1101830939@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
Richard Huxton <dev(at)archonet(dot)com> writes:
> I think you'll find you're out of luck. IIRC there was some discussion 
> on the hackers list regarding a mapping layer that would let you 
> re-order columns. I think the decision was "too much work for too small 
> a gain".

Yup, that was exactly the conclusion.  Too much work and too much risk
of introducing bugs (by using the wrong one of logical and physical
column number in any given place).

You really have to drop and recreate the table if you want to reorder
the columns.

			regards, tom lane

In response to

Responses

pgsql-general by date

Next:From: MaxDate: 2004-11-30 16:12:06
Subject: Re: [ANNOUNCE] USENET vs Mailing Lists Poll ...
Previous:From: Pierre-Frédéric CaillaudDate: 2004-11-30 16:02:19
Subject: Re: VACUUM and ANALYZE Follow-Up

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group