Re: BUG #4412: Check constraints cannot be added to the table for fields that are mixed case

On Tue, Sep 9, 2008 at 3:11 PM, Kevin <kevin@rtvision.com> 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 !=3D 'Kevin')


--=20
regards,
Jaime Casanova
Soporte y capacitaci=F3n de PostgreSQL
Asesor=EDa y desarrollo de sistemas
Guayaquil - Ecuador
Cel. (593) 87171157