Skip site navigation (1) Skip section navigation (2)

Re: case sensititvity bug in foreign keys on cygwin

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Mike Smialek <_ike_mialek(at)hotmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: case sensititvity bug in foreign keys on cygwin
Date: 2001-12-04 00:34:37
Message-ID: 3C0C1A1D.3EA11418@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-bugspgsql-hackers
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

In response to

pgsql-hackers by date

Next:From: Christopher Kings-LynneDate: 2001-12-04 01:36:18
Subject: Re: An easy question about creating a primary key
Previous:From: mkscottDate: 2001-12-03 23:20:44
Subject: Using Threads (again)

pgsql-admin by date

Next:From: Tony ReinaDate: 2001-12-04 01:13:11
Subject: Re: psql option for writing schema
Previous:From: Jeremy BuchmannDate: 2001-12-03 23:23:54
Subject: Re: problems with postgresql speed

pgsql-bugs by date

Next:From: Tom LaneDate: 2001-12-04 01:30:56
Subject: Re: Bug #529: UPDATE fails after an index is changed
Previous:From: pgsql-bugsDate: 2001-12-04 00:12:11
Subject: Bug #529: UPDATE fails after an index is changed

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group