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

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