pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Missing lock conflict for ROW SHARE
2+ messages / 2 participants
[nested] [flat]

* Missing lock conflict for ROW SHARE
@ 2017-04-12 10:00  diemersebastien@yahoo.fr
  0 siblings, 1 reply; 2+ messages in thread

From: diemersebastien@yahoo.fr @ 2017-04-12 10:00 UTC (permalink / raw)
  To: pgsql-docs

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


^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Missing lock conflict for ROW SHARE
@ 2017-04-21 19:39  Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
  parent: diemersebastien@yahoo.fr
  0 siblings, 0 replies; 2+ messages in thread

From: Peter Eisentraut @ 2017-04-21 19:39 UTC (permalink / raw)
  To: diemersebastien@yahoo.fr; pgsql-docs

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=3e33b...;

-- 
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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2017-04-21 19:39 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-04-12 10:00 Missing lock conflict for ROW SHARE diemersebastien@yahoo.fr
2017-04-21 19:39 ` Peter Eisentraut <peter.eisentraut@2ndquadrant.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox