On Tue, Sep 9, 2008 at 3:11 PM, Kevin <kevin(at)rtvision(dot)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 != 'Kevin')
--
regards,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. (593) 87171157