Horton

Re: BUG #15733: An insert destined at partition created after a column has been dropped from the parent table fails

Michael Paquier <michael@paquier.xyz>

View thread View on postgr.es
From: Michael Paquier <michael@paquier.xyz>
To: Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Cc: petr.fedorov@phystech.edu, pgsql-bugs@lists.postgresql.org
Date: 2019-04-08T04:50:20Z
Lists: pgsql-bugs 
On Fri, Apr 05, 2019 at 02:07:22PM +0900, Amit Langote wrote:
> I also rewrote tests a bit too, expanding the comment, and finding even
> more suitable place in insert.sql to add this test than v2.

Finally done.  My apologies for the time it took.  I have expanded the
tests a bit more, tweaked a couple of comments and a bit the logic,
then committed the fix to v11, with the extra set of regression tests
added on HEAD.  Thanks for the patch, Amit, and thanks for the report,
Petr!
--
Michael

Commits

  1. Fix partition tuple routing with dropped attributes

  2. Add more tests for partition tuple routing with dropped attributes