Re: Another FK violation when referencing a multi-level partitioned table

Alvaro Herrera <alvherre@2ndquadrant.com>

From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, pgsql-bugs@lists.postgresql.org
Date: 2020-02-20T19:43:54Z
Lists: pgsql-bugs
On 2020-Feb-10, Jehan-Guillaume de Rorthais wrote:

> > FWIW, I think the test query is too smart for its own good:
> > [...]
> 
> Indeed, thank you. Please find in attachment a patch making the test simpler.

Thanks!  Pushed.

I also signed this commit, as an experiment.  Our gitweb doesn't show
anything, but github adds a "verified" badge to it.  (I had to upload my
public GPG key for this.)  Nothing in the git command line shows
anything about the commit being signed either; you have to ask for it
explicitly.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



Commits

  1. Simplify FK-to-partitioned regression test query

  2. Fix failure to create FKs correctly in partitions