Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id A95EB4768EC for ; Tue, 7 Jan 2003 07:53:12 -0500 (EST) Received: from mail2.tpgi.com.au (mail.tpgi.com.au [203.12.160.58]) by postgresql.org (Postfix) with ESMTP id 397464767E0 for ; Tue, 7 Jan 2003 07:53:11 -0500 (EST) Received: from jac (bri-ts3-2600-139.tpgi.com.au [203.219.26.139]) by mail2.tpgi.com.au (8.11.6/8.11.6) with SMTP id h07CrCQ05976 for ; Tue, 7 Jan 2003 23:53:12 +1100 Message-ID: <001601c2b64b$ba8c3b30$1400a8c0@jac> From: "jack" To: Subject: A problem about alter table Date: Tue, 7 Jan 2003 22:53:06 +1000 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/57 X-Sequence-Number: 10922 Hi, all I'm using postgreSQL 7.2.3. The following statement always cuases a parser error, "parse error at or near NOT". Please adivse, thank you in advance. ALTER TABLE _acct_group1 ALTER groupkey SET NOT NULL; Jack