Re: [PERFORM] Odd Locking Problem

2005-08-15 Thread Manfred Koizar
On Thu, 11 Aug 2005 16:11:58 -0500, John A Meinel <[EMAIL PROTECTED]> wrote: >the insert is occurring into table 'a' not table 'b'. >'a' refers to other tables, but these should not be modified. So your "a" is Alvaro's "b", and one of your referenced tables is Alvaro's "a". This is further suppor

Re: [PERFORM] Odd Locking Problem

2005-08-11 Thread John A Meinel
Alvaro Herrera wrote: > On Thu, Aug 11, 2005 at 03:36:31PM -0500, John A Meinel wrote: > ... > > This is a known problem, solved in 8.1. A workaround for previous > releases is to defer FK checks until commit: So I don't know exactly what the fix was, but I just tested, and my problem is indeed

Re: [PERFORM] Odd Locking Problem

2005-08-11 Thread John A Meinel
Alvaro Herrera wrote: > On Thu, Aug 11, 2005 at 03:36:31PM -0500, John A Meinel wrote: > >>I'm having an odd case where my system is locking such that if I insert >>into a table during a transaction, if I start a new connection and >>transaction, it blocks while trying to do a similar insert until

Re: [PERFORM] Odd Locking Problem

2005-08-11 Thread Alvaro Herrera
On Thu, Aug 11, 2005 at 03:36:31PM -0500, John A Meinel wrote: > I'm having an odd case where my system is locking such that if I insert > into a table during a transaction, if I start a new connection and > transaction, it blocks while trying to do a similar insert until the > first transaction is

[PERFORM] Odd Locking Problem

2005-08-11 Thread John A Meinel
I'm having an odd case where my system is locking such that if I insert into a table during a transaction, if I start a new connection and transaction, it blocks while trying to do a similar insert until the first transaction is committed or rolled back. The schema is rather complex (currently 157