On Tue, Sep 9, 2008 at 3:11 PM, Kevin <[EMAIL PROTECTED]> wrote: > Description: Check constraints cannot be added to the table for > fields that are mixed case > Details: > > Check constraints cannot be added to the table for fields that are mixed > case. > > Example - field employeeName in table Employees
postgres converts all your uppercase in object names to lowercase... if you really want mixed case you must put the name in quotes. Try with: ALTER TABLE "Employees" ADD CONSTRAINT employeenametest CHECK (employeename != 'Kevin') -- regards, Jaime Casanova Soporte y capacitación de PostgreSQL AsesorÃa y desarrollo de sistemas Guayaquil - Ecuador Cel. (593) 87171157 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
