Postgres Pro
Downloads
Home   >   mailing lists

Re: Does DROP TABLE on table A with foreign key to table B locksSELECT queries on table B? - Mailing list pgsql-novice

From Laurenz Albe
Subject Re: Does DROP TABLE on table A with foreign key to table B locksSELECT queries on table B?
Date
Msg-id 2bdf0fe5679f44ebf56890dfd5c5ead21a0c0bc3.camel@cybertec.at
Whole thread Raw
In response to Does DROP TABLE on table A with foreign key to table B locks SELECTqueries on table B?  (Tomer Praizler <tomer.praizler@gmail.com>)
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: Tomer Praizler
Date:
Subject: Does DROP TABLE on table A with foreign key to table B locks SELECTqueries on table B?
Next
From: "Saifi Khan"
Date:
Subject: compiling PostgreSQL with --enable-llvm