Horton
Menu

Re: error creating table that worked under 7.0.3

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Kyle F. Downey" <kdowney@amberarcher.com>
Cc: pgsql-bugs@postgresql.org
Date: 2001-04-13T15:59:58Z
Lists: pgsql-bugs 
"Kyle F. Downey" <kdowney@amberarcher.com> writes:
> In 7.1rc2, this same DDL results in this error:

> ERROR:  UNIQUE constraint matching given keys for referenced table 
> "incidents" not found

7.1 enforces the requirement that the referenced column be marked UNIQUE
(or PRIMARY KEY, which implies UNIQUE).  Seems to work if you add that.

			regards, tom lane