The following bug has been logged online: Bug reference: 4412 Logged by: Kevin Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.15 Operating system: Gentoo Linux 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 --------- ALTER TABLE "Employees" ADD CONSTRAINT "employeeNameTest" CHECK (employeeName != 'Kevin') ---- results in --- ERROR: column "employeename" does not exist --------- I'm new to postgreSql, and using phppgadmin (also tried this with psql), so haven't tried putting check directly on the field/column instead of the table. Also, the constraint I'm really trying to write requires referencing 2 columns. For now, I switched the field names (to employee_name for example). -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
