Re: Transaction oddity with list partition of a list partition

From: Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>
To: David Fetter <david(at)fetter(dot)org>, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Transaction oddity with list partition of a list partition
Date: 2016-12-15 09:20:04
Message-ID: 500426e3-b71c-19fb-9eed-a1cfe5c71bdd@lab.ntt.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Hi David,

On 2016/12/15 18:09, David Fetter wrote:
> Per Thomas Munro, could it be that the CREATE ... PARTITION OF ... code
> fails to run CacheInvalidateRelcache on its parent(s)?

Thomas's right. There is a patch posted for this issue [1]; I'm sending
an updated version of the patch later today in reply to [1]. Meanwhile,
could you try and see if the problem is fixed with the attached patch.

Thanks,
Amit

[1]
https://www.postgresql.org/message-id/CA%2BTgmoZ86v1G%2Bzx9etMiSQaBBvYMKfU-iitqZArSh5z0n8Q4cA%40mail.gmail.com

Attachment Content-Type Size
0001-Invalidate-the-parent-s-relcache-after-partition-cre.patch text/x-diff 3.1 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2016-12-15 09:25:10 Re: Crash on promotion when recovery.conf is renamed
Previous Message Amit Kapila 2016-12-15 09:17:31 Re: Hang in pldebugger after git commit : 98a64d0