Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: alter table question for 7.2
- From: Andreas Kretschmer <akretschmer(at)spamfence(dot)net>
- To: pgsql-novice(at)postgresql(dot)org
- Subject: Re: alter table question for 7.2
- Date: Tue, 24 Mar 2009 18:54:56 +0100
- Message-id: <20090324175456.GA32674@tux> <text/plain>
Matthias Leopold <matthias(at)aic(dot)at> wrote: > hi, > > can anyone tell me the right way to do something like > > alter table foo add column bar int not null default '0'; > > in a postgresql 7.2 database? Update now! IIRC, first add the column and then use ALTER TABLE SET DEFAULT. Try that, i'm not sure, 7.2 is too old. Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknown) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
- Follow-Ups:
- Re: alter table question for 7.2
- From: Tom Lane
- Re: alter table question for 7.2
- References:
- alter table question for 7.2
- From: Matthias Leopold
- alter table question for 7.2
- Prev by Date: alter table question for 7.2
- Next by Date: Re: alter table question for 7.2
- Previous by thread: alter table question for 7.2
- Next by thread: Re: alter table question for 7.2
- Indexes: