Re: [GENERAL] Foreign keys causing conflicts leading toserialization failures

2008-04-03 Thread Albe Laurenz
Tom Lane wrote: This is what I am wondering. Whether it is done this way due to expecation/standard, or as an implementation side effect. In the latter case it is fixable. I don't see how this could break a standard. Actually, I think it does, because we went to great lengths to cause

Re: [GENERAL] Foreign keys causing conflicts leading toserialization failures

2008-04-02 Thread Albe Laurenz
Peter Schuller wrote: [about a serialization error caused by a foreign key constraint] Transaction 2 now issues an INSERT on atable. This requires a RowShareLock on the index row of the index on othertable that is referenced by the foreign key constraint. But the corresponding index row has

Re: [GENERAL] Foreign keys causing conflicts leading toserialization failures

2008-04-02 Thread Tom Lane
Albe Laurenz [EMAIL PROTECTED] writes: Peter Schuller wrote: This is what I am wondering. Whether it is done this way due to expecation/standard, or as an implementation side effect. In the latter case it is fixable. I don't see how this could break a standard. Actually, I think it does,