X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 98FBDD1DCEE for ; Wed, 10 Mar 2004 13:07:51 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 74722-01 for ; Wed, 10 Mar 2004 09:07:52 -0400 (AST) Received: from anchor-post-34.mail.demon.net (anchor-post-34.mail.demon.net [194.217.242.92]) by svr1.postgresql.org (Postfix) with ESMTP id 964CDD1DC9D for ; Wed, 10 Mar 2004 09:07:48 -0400 (AST) Received: from tmsl-adsl.demon.co.uk ([80.177.114.181] helo=bacon.tmsl.demon.co.uk) by anchor-post-34.mail.demon.net with esmtp (Exim 3.35 #1) id 1B13R9-000LF2-0Y; Wed, 10 Mar 2004 13:07:51 +0000 Date: Wed, 10 Mar 2004 13:07:49 +0000 From: Paul Thomas To: David Cc: "pgsql-sql @ postgresql . org" Subject: Re: changing constraints Message-ID: <20040310130749.A14958@bacon> References: <403F762B.20002@aol.net> <20773.1077905537@sss.pgh.pa.us> <008901c4069c$ba6591e0$49660c81@ad.kent.ac.uk> Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset=ISO-8859-1 In-Reply-To: <008901c4069c$ba6591e0$49660c81@ad.kent.ac.uk>; from de4@kent.ac.uk on Wed, Mar 10, 2004 at 12:27:05 +0000 X-Mailer: Balsa 1.2.3 Lines: 34 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/103 X-Sequence-Number: 17202 On 10/03/2004 12:27 David wrote: > I tried adding a constraint thus: > de4=> ALTER TABLE genus ADD CHECK(gender = 'masculine' || 'feminine'); > But get the msg: > ERROR: AlterTableAddConstraint: rejected due to CHECK constraint $2 > > de4=> \d genus > Table "public.genus" > Column | Type | Modifiers > ----------------+-----------------------+----------- > genus_name | character varying(20) | not null > gender | character varying(10) | > cas_gen_number | integer | > family_name | character(7) | > Indexes: genus_pkey primary key btree (genus_name) > Foreign Key constraints: $1 FOREIGN KEY (family_name) REFERENCES > family(family_name) ON UPDATE NO ACTION ON DELETE NO ACTION > > I cant see a $2 constraint so why am i getting the error msg? > > Many thanks Dave Just guessing but maybe it's because gender is nullable? -- Paul Thomas +------------------------------+---------------------------------------------+ | Thomas Micro Systems Limited | Software Solutions for Business | | Computer Consultants | http://www.thomas-micro-systems-ltd.co.uk | +------------------------------+---------------------------------------------+