On Tue, Jul 9, 2013 at 9:02 AM, <pgn...@gmail.com> wrote: > The following bug has been logged on the website: > > Bug reference: 8290 > Logged by: pgnoob > Email address: pgn...@gmail.com > PostgreSQL version: 8.4.13 > Operating system: CentOS Linux > Description: > > I experienced a db deadlock. After tracking down the problem I attributed > it to some unusual locking behavior in postgresql where it acquires locks > in > an unexpected way that contributed to the deadlock. > > > ALTER TABLE B ADD CONSTRAINT fkrefa FOREIGN KEY (a_id) REFERENCES A(id) > MATCH FULL; >
Try those steps again with the FK "DEFERRABLE INITIALLY DEFERRED" Eg. ALTER TABLE B ADD CONSTRAINT fkrefa FOREIGN KEY (a_id) REFERENCES A(id) MATCH FULL deferrable initially deferred;
