Postgres Pro
Downloads
Home   >   mailing lists

Re: error creating table that worked under 7.0.3 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: error creating table that worked under 7.0.3
Date
Msg-id 4141.987177598@sss.pgh.pa.us
Whole thread Raw
In response to error creating table that worked under 7.0.3  ("Kyle F. Downey" <kdowney@amberarcher.com>)
List pgsql-bugs
Tree view 
"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

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: bug in 7.0.3 related to triggers and field rename
Next
From: Tom Lane
Date:
Subject: Re: runtest bug and bigcheck problems