Re: [GENERAL] I'm no longer puzzled by a foreign key constraint problem

2008-11-06 Thread Craig Ringer
Jonathan Guthrie wrote: >> Tom Lane pointed out where to go from here re the server logging. It'll >> be interesting to see what turns up once you've got new logs that show >> the backend pid and the involved xid. > > I'll be keeping Mr. Lane's message for the logging tips. For my own > part, si

Re: [GENERAL] I'm no longer puzzled by a foreign key constraint problem

2008-11-06 Thread Jonathan Guthrie
On Wed, 2008-11-05 at 12:14 +0900, Craig Ringer wrote: > Jonathan Guthrie wrote: > > > The thing is, the C++ code does this > > > > BEGIN transaction 1 > > INSERT project > > COMMIT > > > > BEGIN transaction 2 > > SET permissions > > COMMIT > > > > or, at least, it's supposed to. > > OK, and w