pgsql: Lock all relations referred to in updatable views

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема pgsql: Lock all relations referred to in updatable views
Дата
Msg-id E1ZZQ2v-0001vC-9O@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Lock all relations referred to in updatable views

Even views considered "simple" enough to be automatically updatable may
have mulitple relations involved (eg: in a where clause).  We need to
make sure and lock those relations when rewriting the query.

Back-patch to 9.3 where updatable views were added.

Pointed out by Andres, patch thanks to Dean Rasheed.

Branch
------
REL9_5_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/9801bae217e9d3f72e2d1f3dd780bf0bf9365dae

Modified Files
--------------
src/backend/rewrite/rewriteHandler.c |   15 +++++++++++++++
1 file changed, 15 insertions(+)


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

Предыдущее
От: Andres Freund
Дата:
Сообщение: pgsql: psql: Generic tab completion support for enum and bool GUCs.
Следующее
От: Stephen Frost
Дата:
Сообщение: pgsql: Lock all relations referred to in updatable views