Re: pgadmin3 -- adding CHECK constraint

On Thu, Sep 29, 2011 at 4:34 AM, Bob Vandy <srehtvandy(at)gmail(dot)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.
>