Re: pgadmin3 -- adding CHECK constraint

If your column name is Status you have to write 'Status'

________________________________
From: Bob Vandy <srehtvandy(at)gmail(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Sent: Wednesday, September 28, 2011 8:04 PM
Subject: [pgadmin-support] pgadmin3 -- adding CHECK constraint

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.