Thread: adding default values doesn't work

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/

Kevin L <kevinsl@yahoo.com> writes:
> Hi. I'm running Postgres 6.5.3 and want to add a column with
> "default 0" to an existing table.

Try updating to something more recent ...

            regards, tom lane