pgsql: Lock all relations referred to in updatable views

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Lock all relations referred to in updatable views
Date: 2015-09-08 21:03:17
Message-ID: E1ZZQ2v-0001vE-9W@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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_4_STABLE

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

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

Browse pgsql-committers by date

  From Date Subject
Next Message Andrew Dunstan 2015-09-08 21:19:52 Re: pgsql: Improve logging of TAP tests.
Previous Message Andres Freund 2015-09-08 19:00:02 pgsql: psql: Generic tab completion support for enum and bool GUCs.