Re: [SQL] WHY transaction waits for another transaction?

2005-06-19 Thread Tom Lane
Vilinski Vladimir [EMAIL PROTECTED] writes: During the execution of transaction Nr:10295 (PID:18430) one new transaction with Nr:10339 (PID:18431) starts, that writes one record into the table. But this new transaction never stops, because it tries to set one ShareLock to its parrent

Re: [SQL] WHY transaction waits for another transaction?

2005-06-19 Thread Michael Fuhr
On Tue, Jun 14, 2005 at 01:12:13PM +0200, Vilinski Vladimir wrote: During the execution of transaction Nr:10295 (PID:18430) one new transaction with Nr:10339 (PID:18431) starts, that writes one record into the table. But this new transaction never stops, because it tries to set one

Re: [SQL] WHY transaction waits for another transaction?

2005-06-19 Thread Michael Fuhr
On Sun, Jun 19, 2005 at 09:58:11AM -0600, Michael Fuhr wrote: If possible, it would be best to commit transactions that insert or update foreign keys as soon as possible. I probably shouldn't have said best here, implying that this solution is better than all other possibilities. As Tom Lane

[SQL] WHY transaction waits for another transaction?

2005-06-18 Thread Vilinski Vladimir
Hallo I'm porting one Oracle Application to Postgres. This Programm uses long living Transactions. During the execution of transaction Nr:10295 (PID:18430) one new transaction with Nr:10339 (PID:18431) starts, that writes one record into the table. But this new transaction never stops, because