Correction in SHARE ROW EXCLUSIVE lock description

From: diemersebastien(at)yahoo(dot)fr
To: pgsql-docs(at)postgresql(dot)org
Subject: Correction in SHARE ROW EXCLUSIVE lock description
Date: 2017-10-09 09:07:48
Message-ID: [email protected]
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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
?

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message David G. Johnston 2017-10-10 14:46:44 Re: 19.2. File Locations doesn't tell you the file locations!
Previous Message Pantelis Theodosiou 2017-10-06 13:08:24 Changes in serial / sequence introduced in Postgresql 10