| From: | Gerard Samuel <gsam(at)trini0(dot)org> |
|---|---|
| To: | pgsql-php(at)postgresql(dot)org |
| Subject: | Adding a new column |
| Date: | 2003-01-23 17:20:24 |
| Message-ID: | 3E302458.3000304@trini0.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-php |
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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Trutwin | 2003-01-23 17:33:18 | Re: PHP Abstraction Layer - Your Opinion Please |
| Previous Message | Andrei Verovski (aka MacGuru) | 2003-01-23 15:51:38 | PHP Abstraction Layer - Your Opinion Please |