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(-)
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. |