I have a table with data in it, and Im trying to add another column to it.
Im executing ->
ALTER TABLE search_content ADD COLUMN faq_id VARCHAR(33);
then
alter table search_content alter column faq_id set default '' not null;
Im getting an error ->
ERROR: parser: parse error at or near "null"
If I take out not null, the sql works but I need the column to be "not null"
What am I doing wrong???
Thanks
--
Gerard Samuel
http://www.trini0.org:81/
http://dev.trini0.org:81/
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo [at] postgresql.org)
