Re: ALTER TABLE DROP COLUMN

> On Mon, 9 Oct 2000, Tom Lane wrote:
> 
> > The Hermit Hacker <scrappy@hub.org> writes:
> > >> What happens if you crash partway through?
> > 
> > > what happens if you crash partway through a vacuum?
> > 
> > Nothing.  Vacuum is crash-safe.  ALTER TABLE should be too.
> 
> Sorry, that's what I meant ... why should marking a column as 'deleted'
> and running a 'vacuum' to clean up the physical table be any less
> crash-safe?  

It is not.  The only downside is 2x disk space to make new versions of
the tuple.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026