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

From Tom Lane
Subject Re: ALTER TABLE DROP COLUMN
Date
Msg-id 715.960822061@sss.pgh.pa.us
Whole thread Raw
In response to Re: ALTER TABLE DROP COLUMN  (Chris Bitmead <chris@bitmead.com>)
List pgsql-hackers
Chris Bitmead <chris@bitmead.com> writes:
> I don't know if this is one of the 5, but my idea of a good
> implementation is to do the fast invisible approach, and then update
> individual tuples to the new format the next time they happen to be
> UPDATEd.

How would you tell whether a particular tuple has been updated or not?

Furthermore, how would you remember the old tuple format (or formats)
so that you'd know how to make the conversion?

Seems to me this approach would require adding some sort of table
version number to every tuple header, plus storing a complete set of
system catalog entries for every past version of each table's schema.
That's a heck of a high price, in both storage and complexity, for a
feature of dubious value...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Gripe: working on configure now requires Automake installed locally
Next
From: Karel Zak
Date:
Subject: the contrib