Re: ALTER TABLE DROP COLUMN - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: ALTER TABLE DROP COLUMN
Date
Msg-id Pine.LNX.4.21.0002280034590.2468-100000@localhost.localdomain
Whole thread Raw
In response to ALTER TABLE DROP COLUMN  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: [HACKERS] Re: ALTER TABLE DROP COLUMN
List pgsql-hackers
Bruce Momjian writes:

> You can exclusively lock the table, then do a heap_getnext() scan over
> the entire table, remove the dropped column, do a heap_insert(), then a
> heap_delete() on the current tuple,

Wow, that almost seems to easy to be true. I never thought that having
tuples of different structures in the table at the same time would be
possible. If so then I don't see a reason why this would be too hard to
do.


-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden




pgsql-hackers by date:

Previous
From: Keith Parks
Date:
Subject: Rogue line in regression resultmap file.
Next
From: Peter Eisentraut
Date:
Subject: Re: [HACKERS] update_pg_pwd trigger does not work very well