momjian(at)svr1(dot)postgresql(dot)org (Bruce Momjian) writes:
> someone asked me about the FK deadlock fix, mentioned in the 7.3.3
> release notes as 3rd change:
> http://www.postgresql.org/docs/current/static/release-7-3-3.html
> Actually, that fix was available with 7.4, not 7.3. Don't know if we can
> retroactively change the release-notes though.
This is completely erroneous, please undo it.
2003-05-21 14:14 tgl
* src/: backend/utils/adt/ri_triggers.c,
test/regress/expected/foreign_key.out (REL7_3_STABLE): Back-patch
Jan's fix to avoid primary key lookup (and lock) if foreign key
does not change on UPDATE.
regards, tom lane