Re: ERROR: there is no unique constraint matching given keys for referenced table "audit_p"

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Mon, Nov 18, 2019 at 1:01 PM Miles Elam <miles.elam@xxxxxxxxxxxxxx> wrote:

I was under the impression that PostgreSQL 12 removed this limitation. Was this incorrect?

https://www.2ndquadrant.com/en/blog/postgresql-12-foreign-keys-and-partitioned-tables/

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.