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

Re: ALTER TABLE TODO items

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Stephen Frost <sfrost(at)snowman(dot)net>
Cc: Tom Lane <tgl(at)svr1(dot)postgresql(dot)org>,PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: ALTER TABLE TODO items
Date: 2004-05-05 15:38:34
Message-ID: 200405051538.i45FcYU01529@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-committerspgsql-hackers
Stephen Frost wrote:
> > I don't think so.  As I remember it was part of doing logical attribute
> > numbers as a way to add ALTER COLUMN TYPE, but because we now use table
> > recreate to implement this, it is unlikely we will ever add logical
> > attribute numbers (adds too much complexity to the code).
> 
> Does using table recreate break views built against the table?  I recall
> someone saying the old way did, it would be very nice if that could be
> fixed or at least added to the TODO.  I like the idea of being able to
> alter the positions of the columns too, but that's not as big of an
> issue as breaking views.

Yea, I think it will break views. You have to recreate them.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

pgsql-hackers by date

Next:From: Greg StarkDate: 2004-05-05 15:57:07
Subject: Re: PostgreSQL pre-fork speedup
Previous:From: Stephen FrostDate: 2004-05-05 15:30:36
Subject: Re: ALTER TABLE TODO items

pgsql-committers by date

Next:From: Tom LaneDate: 2004-05-05 16:09:31
Subject: pgsql-server/src/bin/initdb initdb.c
Previous:From: Stephen FrostDate: 2004-05-05 15:30:36
Subject: Re: ALTER TABLE TODO items

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