Re: BETWEEN Node & DROP COLUMN - Mailing list pgsql-hackers

From Rod Taylor
Subject Re: BETWEEN Node & DROP COLUMN
Date
Msg-id 1025695490.232.501.camel@jester
Whole thread Raw
In response to BETWEEN Node & DROP COLUMN  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-hackers
> all values, drop the old col).  So, there is no reason why this new
> attisdropped field shouldn't allow us to implement a full ALTER TABLE/SET
> TYPE sort of feature - cool huh?


I've not looked in a while, but the column rename code did not account
for issues in foreign keys, etc.  Those should be easier to ferret out
soon, but may not be so nice to change yet.

It should also be noted that an ALTER TABLE / SET TYPE implemented with
the above idea with run into the 2x diskspace issue as well as take
quite a while to process.





pgsql-hackers by date:

Previous
From: Rod Taylor
Date:
Subject: Re: listen/notify argument (old topic revisited)
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Re: BETWEEN Node & DROP COLUMN