Postgres Pro
Downloads
Home   >   mailing lists

[DOCS] Correction in SHARE ROW EXCLUSIVE lock description - Mailing list pgsql-docs

From diemersebastien@yahoo.fr
Subject [DOCS] Correction in SHARE ROW EXCLUSIVE lock description
Date
Msg-id 20171009090748.14648.18871@wrigleys.postgresql.org
Whole thread Raw
Responses Re: [DOCS] Correction in SHARE ROW EXCLUSIVE lock description  (Euler Taveira <euler@timbira.com.br>)
List pgsql-docs
Tree view 
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

pgsql-docs by date:

Previous
From: Pantelis Theodosiou
Date:
Subject: [DOCS] Changes in serial / sequence introduced in Postgresql 10
Next
From: "David G. Johnston"
Date:
Subject: Re: [DOCS] 19.2. File Locations doesn't tell you the file locations!