> On Mon, 9 Oct 2000, Tom Lane wrote: > > > The Hermit Hacker <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
- Re: [HACKERS] ALTER TABLE DROP COLUMN Hiroshi Inoue
- Re: [HACKERS] ALTER TABLE DROP COLUMN Philip Warner
- Re: [HACKERS] ALTER TABLE DROP COLUMN The Hermit Hacker
- Re: [HACKERS] ALTER TABLE DROP COLUMN Bruce Momjian
- Re: [HACKERS] ALTER TABLE DROP COLUMN Tom Lane
- Re: [HACKERS] ALTER TABLE DROP COLUMN Bruce Momjian
- Re: [HACKERS] ALTER TABLE DROP COLUMN The Hermit Hacker
- Re: [HACKERS] ALTER TABLE DROP COLUMN The Hermit Hacker
- Re: [HACKERS] ALTER TABLE DROP COLUMN Tom Lane
- Re: [HACKERS] ALTER TABLE DROP COLUMN The Hermit Hacker
- Re: [HACKERS] ALTER TABLE DROP COLUMN Bruce Momjian
- Re: [HACKERS] ALTER TABLE DROP COLUMN The Hermit Hacker
- Re: [HACKERS] ALTER TABLE DROP COLUMN Bruce Momjian
- Re: [HACKERS] ALTER TABLE DROP COLUMN The Hermit Hacker
- Re: [HACKERS] ALTER TABLE DROP COLUMN Tom Lane
- Re: [HACKERS] ALTER TABLE DROP COLUMN The Hermit Hacker
- Re: [HACKERS] ALTER TABLE DROP COLUMN Don Baccus
- Re: [HACKERS] ALTER TABLE DROP COLUMN Bruce Momjian
- Re: [HACKERS] ALTER TABLE DROP COLUMN The Hermit Hacker
- Re: [HACKERS] ALTER TABLE DROP COLUMN Bruce Momjian
- Re: [HACKERS] ALTER TABLE DROP COLUMN The Hermit Hacker