pgsql: Allow LOCK TABLE .. ROW EXCLUSIVE MODE with INSERT

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Allow LOCK TABLE .. ROW EXCLUSIVE MODE with INSERT
Date: 2015-05-11 19:44:16
Message-ID: E1Yrtce-0007RL-5d@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Allow LOCK TABLE .. ROW EXCLUSIVE MODE with INSERT

INSERT acquires RowExclusiveLock during normal operation and therefore
it makes sense to allow LOCK TABLE .. ROW EXCLUSIVE MODE to be executed
by users who have INSERT rights on a table (even if they don't have
UPDATE or DELETE).

Not back-patching this as it's a behavior change which, strictly
speaking, loosens security restrictions.

Per discussion with Tom and Robert (circa 2013).

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/fa2642438f189c2b169ace3ac1df19533b9c7781

Modified Files
--------------
doc/src/sgml/ref/lock.sgml | 8 +++++---
src/backend/commands/lockcmds.c | 12 ++++++++----
2 files changed, 13 insertions(+), 7 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Alvaro Herrera 2015-05-11 22:16:25 pgsql: Allow on-the-fly capture of DDL event details
Previous Message Peter Geoghegan 2015-05-11 18:41:20 Re: pgsql: Add support for INSERT ... ON CONFLICT DO NOTHING/UPDATE.