Re: [HACKERS] Well, then you keep your darn columns - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: [HACKERS] Well, then you keep your darn columns
Date
Msg-id 388E462C.D7DCAC4D@tm.ee
Whole thread Raw
In response to Re: [HACKERS] Well, then you keep your darn columns  (The Hermit Hacker <scrappy@hub.org>)
List pgsql-hackers
The Hermit Hacker wrote:
> 
> > numbered.  How does a missing attribute get handled for new rows?
> > My guess is that we have to keep this thing around forever.  Can you
> > imagine having all those user apps tha query pg_attribute supress that
> > column.  Sound like too much work to me.
> 
> I *still* think the best is the "re-write the table in place" method
> ... we already have most of the logic, I would think, from VACUUM ...

It is much safer with vacuum, as there is no way for vacuum to crash and have 
two different tuple formats left behind (i hope ;-p)

-------------
Hannu


pgsql-hackers by date:

Previous
From: "Oliver Elphick"
Date:
Subject: Re: [HACKERS] Column ADDing issues
Next
From: Hannu Krosing
Date:
Subject: Re: Happy column adding (was RE: [HACKERS] Happycolumndropping)