Tomer Praizler wrote:> I am running Postgres 10.X
Yes, dropping a table with a foreign key will take an ACCESS EXCLUSIVE lockon the referenced table. I believe that is because it will drop a (system)trigger on that table.
Yours,Laurenz Albe