Postgres Pro
Downloads
Home   >   mailing lists

Re: ERROR: there is no unique constraint matching given keys forreferenced table "audit_p" - Mailing list pgsql-general

From David G. Johnston
Subject Re: ERROR: there is no unique constraint matching given keys forreferenced table "audit_p"
Date
Msg-id CAKFQuwbL=Zff3hEnNgBW2aoxzNm9AqBkBoikBeSgbFjSZ=aMRw@mail.gmail.com
Whole thread Raw
In response to Re: ERROR: there is no unique constraint matching given keys forreferenced table "audit_p"  (Miles Elam <miles.elam@productops.com>)
List pgsql-general
Tree view
On Mon, Nov 18, 2019 at 1:01 PM Miles Elam <miles.elam@productops.com> wrote:
I was under the impression that PostgreSQL 12 removed this limitation. Was this incorrect?

Yeah, as the comments in that article make clear, the new feature has some rough edges (limitations) that you are hitting with your desired model.

David J.

pgsql-general by date:

Previous
From: Miles Elam
Date:
Subject: Re: ERROR: there is no unique constraint matching given keys forreferenced table "audit_p"
Next
From: "Peter J. Holzer"
Date:
Subject: Re: REINDEX VERBOSE iso-8859-1 option