pg.ddx.io pgsql-docs@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Correction in SHARE ROW EXCLUSIVE lock description 2+ messages / 2 participants [nested] [flat]
* Correction in SHARE ROW EXCLUSIVE lock description @ 2017-10-09 09:07 diemersebastien@yahoo.fr 0 siblings, 1 reply; 2+ messages in thread From: diemersebastien@yahoo.fr @ 2017-10-09 09:07 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: The documentation says : "This lock mode is not automatically acquired by any PostgreSQL command." I am wrong if I say that a "ADD CONSTRAINT toto FOREIGN KEY" command will take a SHARE ROW EXCLUSIVE lock on both tables concerned by the foreign key ? -- 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: Correction in SHARE ROW EXCLUSIVE lock description @ 2017-10-10 15:55 Euler Taveira <euler@timbira.com.br> parent: diemersebastien@yahoo.fr 0 siblings, 0 replies; 2+ messages in thread From: Euler Taveira @ 2017-10-10 15:55 UTC (permalink / raw) To: diemersebastien@yahoo.fr; +Cc: pgsql-docs 2017-10-09 6:07 GMT-03:00 <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: > > The documentation says : > > "This lock mode is not automatically acquired by any PostgreSQL command." > You are reading 9.4 documentation but... > I am wrong if I say that a "ADD CONSTRAINT toto FOREIGN KEY" command will > take a SHARE ROW EXCLUSIVE lock on both tables concerned by the foreign key > ? > ... you are testing with >= 9.5. Indeed, SREL replaced AEL in this ALTER TABLE case [1]. [1] https://www.postgresql.org/docs/9.5/static/explicit-locking.html -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- 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-10-10 15:55 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2017-10-09 09:07 Correction in SHARE ROW EXCLUSIVE lock description diemersebastien@yahoo.fr 2017-10-10 15:55 ` Euler Taveira <euler@timbira.com.br>
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