On Thu, Sep 29, 2011 at 4:34 AM, Bob Vandy <srehtvandy@gmail.com> wrote:
> 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
Hope - you're not missing the quotes around the column name.
--
Thanks & Regards,
Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company
http://www.linkedin.com/in/asheshvashi
>
>
> 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.
>