Re: Dropping constraints on a table locks referenced table... why?

Поиск
Список
Период
Сортировка
От Wells Oliver
Тема Re: Dropping constraints on a table locks referenced table... why?
Дата
Msg-id CAOC+FBXgecnsA8vaUcODiMWK3gCr4UQBVbA6HAwgB6A5DK6+EQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Dropping constraints on a table locks referenced table... why?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Dropping constraints on a table locks referenced table... why?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Dropping constraints on a table locks referenced table... why?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Dropping constraints on a table locks referenced table... why?