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°