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.