From: | Francisco Leovey <fleovey(at)yahoo(dot)com> |
---|---|
To: | Bob Vandy <srehtvandy(at)gmail(dot)com>, "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: pgadmin3 -- adding CHECK constraint |
Date: | 2011-09-29 17:06:37 |
Message-ID: | 1317315997.65759.YahooMailNeo@web39310.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2011-10-04 08:06:39 | Re: pgadmin3 crash report |
Previous Message | Dave Page | 2011-09-29 06:53:58 | Re: Fwd: pgadmin3 -- adding CHECK constraint |