Kevin L <[EMAIL PROTECTED]> 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
---(end of broadcast)---
TIP
Hi. I'm running Postgres 6.5.3 and want to add a column with
"default 0" to an existing table.
alter 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
