Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 3CC37476BA6 for ; Thu, 23 Jan 2003 12:40:00 -0500 (EST) Received: from smtp.comcast.net (smtp.comcast.net [24.153.64.2]) by postgresql.org (Postfix) with ESMTP id 23897477086 for ; Thu, 23 Jan 2003 12:21:48 -0500 (EST) Received: from hivemind.trini0.org (bgp626680bgs.brick201.nj.comcast.net [68.39.132.244]) by mtaout07.icomcast.net (iPlanet Messaging Server 5.2 HotFix 1.09 (built Jan 7 2003)) with ESMTP id <0H9600KRYG5YZM@mtaout07.icomcast.net> for pgsql-php@postgresql.org; Thu, 23 Jan 2003 12:20:22 -0500 (EST) Received: from trini0.org (laptop.trini0.org [192.168.0.5]) by hivemind.trini0.org (Postfix) with ESMTP id 0BFE41FF for ; Thu, 23 Jan 2003 12:20:22 -0500 (EST) Date: Thu, 23 Jan 2003 12:20:24 -0500 From: Gerard Samuel Subject: Adding a new column To: pgsql-php@postgresql.org Message-id: <3E302458.3000304@trini0.org> MIME-version: 1.0 Content-type: text/plain; charset=ISO-8859-1; format=flowed Content-transfer-encoding: 7BIT X-Accept-Language: en, en-us, nl, th User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.1) Gecko/20021213 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/55 X-Sequence-Number: 1800 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/