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

From Wells Oliver
Subject Re: Dropping constraints on a table locks referenced table... why?
Date
Msg-id CAOC+FBXgecnsA8vaUcODiMWK3gCr4UQBVbA6HAwgB6A5DK6+EQ@mail.gmail.com
Whole thread Raw
In response to Re: Dropping constraints on a table locks referenced table... why?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Dropping constraints on a table locks referenced table... why?
List pgsql-admin
Where can I see these triggers? They don't show under the PG Admin trigger tab of course, are they, I don't know, special triggers, stored elsewhere? Can I query an internal PG table?

Just trying to understand better...

On Tue, Apr 17, 2018 at 11:57 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Wells Oliver <wells.oliver@gmail.com> writes:
> 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?

There are triggers on both tables that have to be removed.

                        regards, tom lane



--

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Dropping constraints on a table locks referenced table... why?
Next
From: Tom Lane
Date:
Subject: Re: Dropping constraints on a table locks referenced table... why?