On Tue, 10 Dec 2002, Brian Walker wrote:
> As a test I went into "backend/utils/adt/ri_triggers.c" and removed
> the "FOR UPDATE OF X" from the foreign key checks and the concurrency
> issues disappeared. This still make check 1 happen but removed the
> safety net of check 2.
Right, at which poi
Sorry for this being so long but I want to describe this as thoroughly as possible.
I am having two problems with foreign keys. One is a performance problem and the
other is a deadlock problem but they are related to the same root cause. I am
running PostgreSQL 7.3 (the released version).
I
