Re: BUG #15631: Generated as identity field in a temporary table with on commit drop corrupts system catalogs

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
Cc: Michael Paquier <michael(at)paquier(dot)xyz>, dnsl48(at)gmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15631: Generated as identity field in a temporary table with on commit drop corrupts system catalogs
Date: 2019-04-26 15:09:36
Message-ID: 8521.1556291376@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> writes:
> On 2019-04-25 02:59, Michael Paquier wrote:
>> Is there something else you are considering for this patch? This
>> previous suggestion looks fine to live with, at least for me. Tom,
>> perhaps you have some extra input on the matter and would prefer a
>> more restrictive location for the CCI?

> I didn't find that solution very principled either. I now think the
> best fix is to have a CCI at the end of standard_ProcessUtility(). It's
> very possible that other commands could also create catalog entries that
> some on-commit action would like to see. It wouldn't be sensible to
> chase down each command separately.

Seems reasonable to me. Do we have a concrete patch with that?
The minor-release deadline is getting closer ...

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2019-04-26 15:39:21 Re: BUG #15672: PostgreSQL 11.1/11.2 crashed after dropping a partition table
Previous Message Flo Rance 2019-04-26 13:43:21 Re: Reg: Postgresql8.3 Using on Ubuntu