Re: case sensititvity bug in foreign keys on cygwin

Mike Smialek wrote:
>
> Configuration:
>     Windows 2000 Server
>     cygwin 2.78.2.9
>     PostgreSQL 7.1.3
>     psqlODBC 7.1.8
>     pgAdmin II 1.1.66
>
> Bug:
>     Capital letters cannot be used in column names used in foreign key
> constraints
>
>     All Smalls succeeds:

[snip]

>     Capitalizing just the foreign column name fails with what seems to be
an
> incorrect error:
>         -- Table: significance
>         CREATE TABLE "significance" (
>         "Significanceid" int4 NOT NULL,
>         "desc" varchar(255),
>         CONSTRAINT "pk_significance" PRIMARY KEY ("Significanceid"));
>
>         -- Table: primaryword
>         CREATE TABLE "primaryword" (
>         "exerciseid" int4 NOT NULL,
>         "significanceid" int4 NOT NULL,
>         CONSTRAINT "pk_primaryword" PRIMARY KEY ("exerciseid"),
>         CONSTRAINT "fk_primaryword_significance" FOREIGN KEY
> (significanceid) REFERENCES "significance" (Significanceid) );

You aren't double quoting the column name Significanceid
in the foreign key contraint clauses. Why ?

regards,
Hiroshi Inoue

That is DDL returned from pgAdminII.  The quotes appear to be optional if
you are using all lower case.  With the Quotes, the mixed case works.
Thanks,
MS