Re: [SQL] [ADMIN] Deadlock on transaction

2007-02-12 Thread Scott Marlowe
On Mon, 2007-02-12 at 13:20, Ezequias Rodrigues da Rocha wrote: > This is delphi. I don't intent you understand but the sql actions are > quite simple (I am reading a list of numbers). Hmmm. I'm not seeing anything in your example that should be blocking other transactions. Is there anything tha

Re: [SQL] [ADMIN] Deadlock on transaction

2007-02-12 Thread Richard Huxton
Ezequias Rodrigues da Rocha wrote: This is delphi. I don't intent you understand but the sql actions are quite simple (I am reading a list of numbers). Well, let's see - the last Pascal I did was in 1986 I think... If not dm.database1.InTransaction then dm.database1.StartTra

Re: [SQL] [ADMIN] Deadlock on transaction

2007-02-12 Thread Ezequias Rodrigues da Rocha
This is delphi. I don't intent you understand but the sql actions are quite simple (I am reading a list of numbers). If not dm.database1.InTransaction then dm.database1.StartTransaction; For i:= 0 to memo1.Lines.Count - 1 do Begin // Catching ID

Re: [ADMIN] Deadlock on transaction

2007-02-12 Thread Scott Marlowe
On Mon, 2007-02-12 at 12:08, Ezequias Rodrigues da Rocha wrote: > I mean really deadlock. Other transactions can't access the database > until the main transaction is complete. A question: > > PostgreSQL doesn't permit multiple transactions concurrently ? Again, that's not a deadlock. A deadlock

Re: [SQL] [ADMIN] Deadlock on transaction

2007-02-12 Thread Richard Huxton
Ezequias Rodrigues da Rocha wrote: 2007/2/12, Richard Huxton : Ezequias Rodrigues da Rocha wrote: > I mean really deadlock. Other transactions can't access the database until > the main transaction is complete. A question: > > PostgreSQL doesn't permit multiple transactions concurrently ? PG h

Re: [SQL] [ADMIN] Deadlock on transaction

2007-02-12 Thread Ezequias Rodrigues da Rocha
2007/2/12, Richard Huxton : Ezequias Rodrigues da Rocha wrote: > I mean really deadlock. Other transactions can't access the database until > the main transaction is complete. A question: > > PostgreSQL doesn't permit multiple transactions concurrently ? PG has quite good concurrency behaviour.

Re: [SQL] [ADMIN] Deadlock on transaction

2007-02-12 Thread Richard Huxton
Ezequias Rodrigues da Rocha wrote: I mean really deadlock. Other transactions can't access the database until the main transaction is complete. A question: PostgreSQL doesn't permit multiple transactions concurrently ? PG has quite good concurrency behaviour. And "can't access the database" i

Re: [ADMIN] Deadlock on transaction

2007-02-12 Thread Ezequias Rodrigues da Rocha
I mean really deadlock. Other transactions can't access the database until the main transaction is complete. A question: PostgreSQL doesn't permit multiple transactions concurrently ? Ezequias 2007/2/12, Scott Marlowe <[EMAIL PROTECTED]>: On Mon, 2007-02-12 at 11:43, Ezequias Rodrigues da Roc

Re: [ADMIN] Deadlock on transaction

2007-02-12 Thread Scott Marlowe
On Mon, 2007-02-12 at 11:43, Ezequias Rodrigues da Rocha wrote: > Hi list, > > I am curious becouse I am seen my postgresql locking the transactions > when i load a huge (in some case not to huge) numbers of records > 70,000 records. > > Could someone help me with it ? Are sure that what you're

[ADMIN] Deadlock on transaction

2007-02-12 Thread Ezequias Rodrigues da Rocha
Hi list, I am curious becouse I am seen my postgresql locking the transactions when i load a huge (in some case not to huge) numbers of records 70,000 records. Could someone help me with it ? -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= A