From: Achilleus Mantzios <achill@matrix.gatewaynet.com>
To: David <de4@kent.ac.uk>
Cc: pgsql-sql@postgresql.org
Subject: Re: changing constraints
Date: Wed, 10 Mar 2004 15:41:20 +0200 (EET)
Message-ID: <Pine.LNX.4.44.0403101540070.2365-100000@matrix.gatewaynet.com> (raw)
In-Reply-To: <008901c4069c$ba6591e0$49660c81@ad.kent.ac.uk>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: achill@matrix.gatewaynet.com, de4@kent.ac.uk
Subject: Re: changing constraints
In-Reply-To: <Pine.LNX.4.44.0403101540070.2365-100000@matrix.gatewaynet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox