Skip site navigation (1) Skip section navigation (2)

pgadmin3 -- adding CHECK constraint

From: Bob Vandy <srehtvandy(at)gmail(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: pgadmin3 -- adding CHECK constraint
Date: 2011-09-28 23:04:35
Message-ID: CANVcEWMrJGW-DBVnPRoJ-irraKaDBogUSOZSG-2Eek3Sru4yeg@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-support
I've googled and found no answer for the following:

(I'm using pgAdmin v 1.14.0)

I have a simple table with a column:
     Status       character varying(9) NOT NULL

I try to add a CHECK Constraint, whose definition is:
     Status in ('Assigned', 'Deleted', 'Available')

When I click OK, I get an error:
     ERROR:  column "status" does not exist


What am I doing wrong?
If nothing, and this is a bug, how can I work around it?

Many thanks in advance for any help.

Responses

pgadmin-support by date

Next:From: Bob VandyDate: 2011-09-29 01:59:46
Subject: Fwd: pgadmin3 -- adding CHECK constraint
Previous:From: Bartosz DmytrakDate: 2011-09-27 18:47:35
Subject: Re: ENUM type script in pgAdmin 1.14.0

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group