pgsql: Lock all relations referred to in updatable views - Mailing list pgsql-committers

From Stephen Frost
Subject pgsql: Lock all relations referred to in updatable views
Date
Msg-id E1ZZQ2v-0001vC-9O@gemulon.postgresql.org
Whole thread Raw
List 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 by date:

Previous
From: Andres Freund
Date:
Subject: pgsql: psql: Generic tab completion support for enum and bool GUCs.
Next
From: Stephen Frost
Date:
Subject: pgsql: Lock all relations referred to in updatable views