Re: alter table question for 7.2

Matthias Leopold <matthias@aic.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°