Re: BUG #4648: needless deadlock on tables having foreign-key - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #4648: needless deadlock on tables having foreign-key
Date
Msg-id 19543.1234483834@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #4648: needless deadlock on tables having foreign-key  (Konstantin <kostya2702@rambler.ru>)
Responses Re: BUG #4648: needless deadlock on tables having foreign-key
List pgsql-bugs
Konstantin <kostya2702@rambler.ru> writes:
> I just want to emphasize that mentioned implementation artifact born not
> obvious issues at applications side.

[ shrug... ]  The "implementation artifact" is that you didn't get a
deadlock *earlier*.  You can't expect to update referenced rows and
referencing rows in the same transaction and not risk deadlock against
other transactions doing the same thing.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Konstantin
Date:
Subject: Re: BUG #4648: needless deadlock on tables having foreign-key
Next
From: Scott Carey
Date:
Subject: 8.3.5: Query Planner takes 15+ seconds to plan Update or Delete queries on partitioned tables.