Missing lock conflict for ROW SHARE

Started by Nonameabout 9 years ago2 messagesdocs
Jump to latest
#1Noname
diemersebastien@yahoo.fr

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.4/static/explicit-locking.html
Description:

In my experience ROW SHARE conflicts with ROW EXCLUSIVE and this is not
mentioned in the documentation. Am I missing something ?

--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs

#2Peter Eisentraut
peter_e@gmx.net
In reply to: Noname (#1)
Re: Missing lock conflict for ROW SHARE

On 4/12/17 06:00, diemersebastien@yahoo.fr wrote:

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.4/static/explicit-locking.html
Description:

In my experience ROW SHARE conflicts with ROW EXCLUSIVE and this is not
mentioned in the documentation. Am I missing something ?

This is not correct. See the source for how the lock conflicts are
defined:
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/backend/storage/lmgr/lock.c;h=3e33bc104d3ee71ec87efb0c39485dda4867c00c;hb=c7681b2b9a115eb05048a485480826bc0efa6d3b#l62&gt;

--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs