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
Sorry about this post; I've figured out the problem. It's because I use
mixed-case in my table names and column names, so pgadmin3 quotes them. And
unless my other operations, (Constraints, queries, etc.), quote them as well
this problem occurs.
-- Forwarded message --
From: Bob
On Thu, Sep 29, 2011 at 4:34 AM, Bob Vandy 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:
> Statu
On Thu, Sep 29, 2011 at 2:59 AM, Bob Vandy wrote:
> Sorry about this post; I've figured out the problem. It's because I use
> mixed-case in my table names and column names, so pgadmin3 quotes them. And
> unless my other operations, (Constraints, queries, etc.), quote them as well
> this problem
