Re: Does DROP TABLE on table A with foreign key to table B locks SELECT queries on table B?

Tomer Praizler wrote:
> I am running Postgres 10.X

Yes, dropping a table with a foreign key will take an ACCESS EXCLUSIVE lock
on the referenced table.  I believe that is because it will drop a (system)
trigger on that table.

Yours,
Laurenz Albe