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 A3759D1B4DB for ; Wed, 10 Mar 2004 13:40:47 +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 79192-06 for ; Wed, 10 Mar 2004 09:40:47 -0400 (AST) Received: from matrix.gatewaynet.com (matrix.gatewaynet.com [217.19.69.50]) by svr1.postgresql.org (Postfix) with ESMTP id EA14CD1B4B4 for ; Wed, 10 Mar 2004 09:40:42 -0400 (AST) Received: from matrix.gatewaynet.com (localhost.localdomain [127.0.0.1]) by matrix.gatewaynet.com (8.12.8/8.12.8) with ESMTP id i2ADfKNu002866; Wed, 10 Mar 2004 15:41:20 +0200 Received: from localhost (achill@localhost) by matrix.gatewaynet.com (8.12.8/8.12.8/Submit) with ESMTP id i2ADfKho002862; Wed, 10 Mar 2004 15:41:20 +0200 Date: Wed, 10 Mar 2004 15:41:20 +0200 (EET) From: Achilleus Mantzios To: David Cc: pgsql-sql@postgresql.org Subject: Re: changing constraints In-Reply-To: <008901c4069c$ba6591e0$49660c81@ad.kent.ac.uk> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/104 X-Sequence-Number: 17203 O kyrios David egrapse stis Mar 10, 2004 : > 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 Which pgsql version are you using?? In any case what you wrote means CHECK (gender='masculinefeminine') you should write it as gender = 'masculine' OR gender = 'feminine'. > > 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 > > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings > -- -Achilleus