4 ms·
Foreign key deadlock fix finally after 5 years is out to production! Hopefuly now it is safe to use foreign keys in postgresql :) Haveing table A, B, C with FK
by ghostdiver 13y ago
Foreign key deadlock fix finally after 5 years is out to production! Hopefuly now it is safe to use foreign keys in postgresql :)
Haveing table A, B, C with FK in A and B to C_column1, running function which updates A and other function which updates B, both refering to same C row via FK, but not modyfing it in any way - causes deadlock.
in pre 9.3, now its fixed, so I can use FKs again after so many years and its just creazy:)