Postgres Pro
Downloads
Home   >   mailing lists

foreign key on delete cascade order? - Mailing list pgsql-general

From George Woodring
Subject foreign key on delete cascade order?
Date
Msg-id CACi+J=Tu3O-YAkjtJ=4qYHzrkF2sZv1HNkW7BpaUhmCReXzN1g@mail.gmail.com
Whole thread Raw
Responses Re: foreign key on delete cascade order?
List pgsql-general
Tree view
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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: PQresultMemorySize of ResultSet larger than expected
Next
From: Tom Lane
Date:
Subject: Re: foreign key on delete cascade order?