Re: insert deadlock

Brian Cox <bcox@wilytech.com> writes:

> Thread 1 does 1+ inserts into Table A and 1 update of Table B in a single
> transaction.
> This thread runs on demand.
>
> Thread 2 does 1+ inserts into Table C in a separate transaction.  This thread
> runs once an hour.

I suspect you'll have to include more information than this to get an answer.
At least the \d output for tables A B and C including the foreign keys and
triggers.

Note that you need to worry not just about foreign key columns in tables A, B,
and C, but also any other table that has a foreign key column that refers to
these tables.

--
greg