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/ ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
