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
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 |