foreign key on delete cascade order?

Поиск
Список
Период
Сортировка
От George Woodring
Тема foreign key on delete cascade order?
Дата
Msg-id CACi+J=Tu3O-YAkjtJ=4qYHzrkF2sZv1HNkW7BpaUhmCReXzN1g@mail.gmail.com
обсуждение исходный текст
Ответы Re: foreign key on delete cascade order?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
When using FOREIGN KEY ON DELETE CASCADE, is there an order the entries are being deleted?

We are seeing intermittent deadlocks with trying to update a table with the foreign key entry being deleted.

We have 4 levels of tables chained by foreign keys.

machine -> point -> poll -> status

The status is the only one updated constantly and we are trying to figure out how to order the update to avoid the deadlock when the machine is deleted.

Thanks for your help
George
iGLASS Networks
www.iglass.net

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: PQresultMemorySize of ResultSet larger than expected
Следующее
От: Tom Lane
Дата:
Сообщение: Re: foreign key on delete cascade order?