Horton

Re: Errors creating partitioned tables from existing using (LIKE <table>) after renaming table constraints

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: Stuart <sfbarbee@gmail.com>, pgsql-bugs@postgresql.org
Date: 2018-12-17T03:52:17Z
Lists: pgsql-bugs 
On Mon, Dec 17, 2018 at 11:20:14AM +0900, Amit Langote wrote:
> On 2018/12/17 11:06, Michael Paquier wrote:
>> It seems that the call to relation_close should happen after
>> CacheInvalidateRelcache.  Damn..

That was the issue and this is actually exactly like what has been fixed
in 8082bea2.

> What a blunder!  Sorry. :(

No problem.  I have committed a fix after reproducing the failure
manually and checking the fix.  This should cool down prion now.
--
Michael

Commits

  1. Make constraint rename issue relcache invalidation on target relation