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