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

Поиск
Список
Период
Сортировка
От Thomas Munro
Тема Re: [BUGS] BUG #14799: SELECT * FROM transition_table in astatement-level trigger
Дата
Msg-id CAEepm=2cdVgk1xnRi7pwxY=NLJbFvfrxsQKscGo+W8EU3Fi3mw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [BUGS] BUG #14799: SELECT * FROM transition_table in a statement-level trigger  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [BUGS] BUG #14799: SELECT * FROM transition_table in astatement-level trigger  (Peter Geoghegan <pg@bowt.ie>)
Список 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 по дате отправления:

Предыдущее
От: Patrick van Coeverden
Дата:
Сообщение: [BUGS] Line number in error message is incorrect when loading a CSV-filewith multi-line records.
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: [BUGS] BUG #14799: SELECT * FROM transition_table in astatement-level trigger