Skip site navigation (1) Skip section navigation (2)

Re: Deferred FK / PK deletion problems

From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Deferred FK / PK deletion problems
Date: 2007-10-15 22:11:37
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
Hash: RIPEMD160

Tom Lane wrote:
>> Came across an odd bug while dealing with deferred foreign keys. 

> I'm not convinced this is a bug.

Can you elaborate on this? Am I doing something wrong in my app?
Someone on irc pointed out that this affects more than deferred 
fk, but for my purposes, here's what's happening:

Table A has a primary key.
Table B references that primary key.

Process A periodically updates the table by doing 
(basically) a delete all/insert new data, inside of 
a transaction.

Process B is adding entries to table B.

If Process B happens in the "middle" of Process A, 
the insert to B fails as it claims that the corresponding 
row in table A does not exist.

Short of Process A grabbing an exclusive lock on the table, I 
can't see a way around this. Feel free to punt this to 
general if this is the expected behavior.

- --
Greg Sabino Mullane greg(at)turnstep(dot)com
PGP Key: 0x14964AC8 200710151809


In response to

pgsql-bugs by date

Next:From: Simon RiggsDate: 2007-10-15 22:53:51
Subject: Re: BUG #3667: Job scheduling with Greenplum fails
Previous:From: Dave PageDate: 2007-10-15 21:54:12
Subject: Re: BUG #3667: Job scheduling with Greenplum fails

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group