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

From Hiroshi Inoue
Subject RE: [HACKERS] Well, then you keep your darn columns
Date
Msg-id 001101bf66d8$aad4b8e0$2801007e@tpf.co.jp
Whole thread Raw
In response to Re: [HACKERS] Well, then you keep your darn columns  (The Hermit Hacker <scrappy@hub.org>)
List pgsql-hackers
> -----Original Message-----
> From: The Hermit Hacker [mailto:scrappy@hub.org]
> 
> > 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 ...
>

AFAIK,there's no such logic in VACUUM.  
Because PostgreSQL has no rollback data separately,we must keep
valid old tuples somewhere(of cource the original place is most natural)
in the table until commit at least.

Regards.

Hiroshi Inoue
Inoue@tpf.co.jp



pgsql-hackers by date:

Previous
From: "Hiroshi Inoue"
Date:
Subject: RE: [HACKERS] Happy column dropping
Next
From: Tatsuo Ishii
Date:
Subject: Re: [HACKERS] fatal copy in/out error (6.5.3)