adding default values doesn't work - Mailing list pgsql-general

Hi. I'm running Postgres 6.5.3 and want to add a column with
"default 0" to an existing table.

alter table <table> add column col int4 default 0;

does not work. I've also tried modifying the system table,
pg_attrdef, but that does not work either. I don't want to drop
and recreate the table.

Any ideas anyone?

thanks!

-Kevin

__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/