Re: postgres_fdw : altering foreign table not invalidating prepare statement execution plan.

Поиск
Список
Период
Сортировка
От Amit Langote
Тема Re: postgres_fdw : altering foreign table not invalidating prepare statement execution plan.
Дата
Msg-id e4e81c7a-8f0f-9a26-07d1-91da5f4aa130@lab.ntt.co.jp
обсуждение исходный текст
Ответ на Re: postgres_fdw : altering foreign table not invalidating prepare statement execution plan.  (Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>)
Ответы Re: postgres_fdw : altering foreign table not invalidating prepare statement execution plan.
Список pgsql-hackers
Fujita-san,

On 2016/11/30 17:25, Etsuro Fujita wrote:
> On 2016/11/22 15:24, Etsuro Fujita wrote:
>> On 2016/11/22 4:49, Tom Lane wrote:
> 
>>> OK, please update the patch to handle those catalogs that way.
> 
>> Will do.
> 
> Done.  I modified the patch so that any inval in pg_foreign_server also
> blows the whole plan cache.

Thanks for updating the patch and sorry that I didn't myself.

I noticed the following addition:

+     CacheRegisterSyscacheCallback(FOREIGNDATAWRAPPEROID,
PlanCacheSysCallback, (Datum) 0);

Is that intentional?  I thought you meant only to add for pg_foreign_server.

Thanks,
Amit





В списке pgsql-hackers по дате отправления:

Предыдущее
От: Fabien COELHO
Дата:
Сообщение: Re: PSQL commands: \quit_if, \quit_unless
Следующее
От: Etsuro Fujita
Дата:
Сообщение: Re: postgres_fdw : altering foreign table not invalidating prepare statement execution plan.