From: | Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com> |
---|---|
To: | Bob Vandy <srehtvandy(at)gmail(dot)com> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: pgadmin3 -- adding CHECK constraint |
Date: | 2011-09-29 06:41:16 |
Message-ID: | CAG7mmozR4p0MV5zv7KhdPaECgYBG6yY2vqdwX9G531iLvuD1Fw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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.
>
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2011-09-29 06:53:58 | Re: Fwd: pgadmin3 -- adding CHECK constraint |
Previous Message | Bob Vandy | 2011-09-29 01:59:46 | Fwd: pgadmin3 -- adding CHECK constraint |