Re: error creating table that worked under 7.0.3

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Kyle F(dot) Downey" <kdowney(at)amberarcher(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: error creating table that worked under 7.0.3
Date: 2001-04-13 15:59:58
Message-ID: 4141.987177598@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Kyle F. Downey" <kdowney(at)amberarcher(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2001-04-13 16:06:26 Re: runtest bug and bigcheck problems
Previous Message pgsql-bugs 2001-04-13 11:24:23 bug in 7.0.3 related to triggers and field rename