Postgres Pro
Downloads
Home   >   mailing lists

Re: pgadmin3 -- adding CHECK constraint - Mailing list pgadmin-support

From Francisco Leovey
Subject Re: pgadmin3 -- adding CHECK constraint
Date
Msg-id 1317315997.65759.YahooMailNeo@web39310.mail.mud.yahoo.com
Whole thread Raw
In response to pgadmin3 -- adding CHECK constraint  (Bob Vandy <srehtvandy@gmail.com>)
List pgadmin-support
Tree view
If your column name is Status you have to write 'Status'

From: Bob Vandy <srehtvandy@gmail.com>
To: pgadmin-support@postgresql.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.
 


pgadmin-support by date:

Previous
From: Dave Page
Date:
Subject: Re: Fwd: pgadmin3 -- adding CHECK constraint
Next
From: Guillaume Lelarge
Date:
Subject: Re: pgadmin3 crash report