Re: [BUGS] BUG #14799: SELECT * FROM transition_table in astatement-level trigger - Mailing list pgsql-bugs

From Thomas Munro
Subject Re: [BUGS] BUG #14799: SELECT * FROM transition_table in astatement-level trigger
Date
Msg-id CAEepm=2cdVgk1xnRi7pwxY=NLJbFvfrxsQKscGo+W8EU3Fi3mw@mail.gmail.com
Whole thread Raw
In response to Re: [BUGS] BUG #14799: SELECT * FROM transition_table in a statement-level trigger  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [BUGS] BUG #14799: SELECT * FROM transition_table in astatement-level trigger
List pgsql-bugs
On Thu, Sep 7, 2017 at 1:32 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> phb07@apra.asso.fr writes:
>> I am playing a bit with transition tables in statement-level triggers, using
>> the postgres V10 beta 4 version. I am facing an issue that I suspect to be a
>> bug (unless it is a design limitation). I have built a small test case to
>> reproduce what I have discovered.
>> ...
>> It looks like the resolution of the column list has not taken into account a
>> "NOT attisdropped" condition when scanning the pg_attribute table (or an
>> equivalent in memory structure).
>
> Yeah.  The RTE_NAMEDTUPLESTORE patch seems to have piggybacked on the code
> for RTE_CTE and friends, none of which could have dropped columns so the
> case wasn't considered.  I think the immediate problem is in expandRTE()
> but I have zero faith that there aren't comparable bugs elsewhere.

Ouch.  Thanks for fixing this bug, which I would have picked up if I'd
been awake at the time.

-- 
Thomas Munro
http://www.enterprisedb.com


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

pgsql-bugs by date:

Previous
From: Patrick van Coeverden
Date:
Subject: [BUGS] Line number in error message is incorrect when loading a CSV-filewith multi-line records.
Next
From: Peter Geoghegan
Date:
Subject: Re: [BUGS] BUG #14799: SELECT * FROM transition_table in astatement-level trigger