Re: Invalidation pg catalog cache in trigger functions

From: Константин Евтеев <konst583(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Invalidation pg catalog cache in trigger functions
Date: 2018-01-23 16:09:28
Message-ID: CAAqA9PS8jLJ98MiPOEvocFJp7g092SypGnSVDKmtxiVR7YvMtQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Sorry, I forgot to show version of PostgreSQL:
https://www.postgresql.org/message-id/CAAqA9PQXEmG%3Dk3WpDTmHZL-VKcMpDEA3ZC06Qr0ASO3oTA7bdw%40mail.gmail.com
"Invalidation pg catalog cache in trigger functions"
was detected on "PostgreSQL 9.2.18 on x86_64-unknown-linux-gnu, compiled by
gcc (Ubuntu 4.8.2-19ubuntu1) 4.8.2, 64-bit"
Also it can be reproduced on PostgreSQL 9.2.24
For newer versions it is not actual - PostgreSQL 9.3.20, 9.4.15, 9.4.12

But
Issue
https://www.postgresql.org/message-id/20171030125345.1448.24038@wrigleys.postgresql.org

"BUG #14879: Bug connected with table structure modification and trigger
function query plan invalidation"
Is actual for PostgreSQL 9.2.24; 9.3.20; 9.4.12; 9.4.15

In this thread I propose to find out the cause of
Issue
https://www.postgresql.org/message-id/20171030125345.1448.24038@wrigleys.postgresql.org
"BUG #14879: Bug connected with table structure modification and trigger
function query plan invalidation"

--
Konstantin Evteev

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2018-01-23 16:15:29 Re: [HACKERS] parallel.c oblivion of worker-startup failures
Previous Message Pavel Stehule 2018-01-23 16:08:56 Re: [HACKERS] PoC plpgsql - possibility to force custom or generic plan