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?  (Wells Oliver <wells.oliver@gmail.com>)
Список 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 по дате отправления:

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