Postgres Pro
Downloads
Home   >   mailing lists

Dropping constraints on a table locks referenced table... why? - Mailing list pgsql-admin

From Wells Oliver
Subject Dropping constraints on a table locks referenced table... why?
Date
Msg-id CAOC+FBX7kKHXzfAyeMGn__vE8WoXYpDSR=SUaGtBfTmFoNQpAQ@mail.gmail.com
Whole thread Raw
Responses Re: Dropping constraints on a table locks referenced table... why?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view
I have a table A which has an FK constraint referencing another table B. Dropping this FK constraint on A locks table B, as does trying to drop table A. Why is this?

Is there some more efficient way to remove FK constraints without locking the referenced table?

Thanks for clarification.

--

pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Possible bug on code autocomplete pgadmin V 3.0
Next
From: Tom Lane
Date:
Subject: Re: Dropping constraints on a table locks referenced table... why?