Re: query_id, pg_stat_activity, extended query protocol

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: query_id, pg_stat_activity, extended query protocol
Дата
Msg-id CAKFQuwYyMAg9O4zG-JEf17aJhV2y5wQ=-kDv3xMmzenptPqVTA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: query_id, pg_stat_activity, extended query protocol  ("Imseih (AWS), Sami" <simseih@amazon.com>)
Ответы Re: query_id, pg_stat_activity, extended query protocol  ("Imseih (AWS), Sami" <simseih@amazon.com>)
Список pgsql-hackers
Дерево обсуждения
On Sat, Apr 27, 2024 at 6:55 AM Imseih (AWS), Sami <simseih@amazon.com> wrote:

Hmm, you raise a good point. Isn't this a fundamental problem
with prepared statements? If there is DDL on the
relations of the prepared statement query, shouldn't the prepared
statement be considered invalid at that point and raise an error
to the user?


We choose a arguably more user-friendly option:

"""
Although the main point of a prepared statement is to avoid repeated parse analysis and planning of the statement, PostgreSQL will force re-analysis and re-planning of the statement before using it whenever database objects used in the statement have undergone definitional (DDL) changes or their planner statistics have been updated since the previous use of the prepared statement.
"""

David J.

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

Предыдущее
От: "Imseih (AWS), Sami"
Дата:
Сообщение: Re: query_id, pg_stat_activity, extended query protocol
Следующее
От: "Imseih (AWS), Sami"
Дата:
Сообщение: Re: query_id, pg_stat_activity, extended query protocol