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.
pgadmin-support by date
|Next:||From: Bob Vandy||Date: 2011-09-29 01:59:46|
|Subject: Fwd: pgadmin3 -- adding CHECK constraint|
|Previous:||From: Bartosz Dmytrak||Date: 2011-09-27 18:47:35|
|Subject: Re: ENUM type script in pgAdmin 1.14.0|