Re: BUG #15565: truncate bug with tables which have temp table inherited

From: Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>
To: David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>
Cc: digoal(at)126(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org, PG Bug reporting form <noreply(at)postgresql(dot)org>
Subject: Re: BUG #15565: truncate bug with tables which have temp table inherited
Date: 2018-12-25 08:03:37
Message-ID: 496ce153-fb3b-c8b1-65bd-8a376a88dbc2@lab.ntt.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 2018/12/25 16:27, David Rowley wrote:
> On Tue, 25 Dec 2018 at 13:50, Amit Langote
> <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp> wrote:
>> I'm not sure if the error being shown is a bug, but maybe we could remove
>> the error by making truncate do the same thing as select/update/delete,
>> that is, ignore child tables that are temporary of tables of other
>> sessions. Attached patch to do that.
>
> I glanced at this and was confused at where "newrelation" comes from
> and also the single parameter heap_close(). It does not look like it
> would compile.

Sorry, that was pretty negligent of me. Here's the updated patch.

Thanks,
Amit

Attachment Content-Type Size
truncate-ignore-other-session-temp-children-v2.patch text/plain 880 bytes

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Amit Langote 2018-12-25 08:46:28 Re: BUG #15565: truncate bug with tables which have temp table inherited
Previous Message Michael Paquier 2018-12-25 08:03:14 Re: BUG #15565: truncate bug with tables which have temp table inherited