Обсуждение: pgsql: Lock all relations referred to in updatable views

Поиск
Список
Период
Сортировка

pgsql: Lock all relations referred to in updatable views

От
Stephen Frost
Дата:
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_4_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/83d004904d82759118635dc1a6a7503d4da785e9

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