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