adding default values doesn't work
Started by Kevin Labout 25 years ago2 messagesgeneral
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/
