From: Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
To: Richard Huxton <dev@archonet.com>
Cc: Scott Marlowe <smarlowe@g2switchworks.com>
Cc: pgsql-sql@postgresql.org
Cc: pgsql-admin@postgresql.org
Subject: Re: [SQL] Deadlock on transaction
Date: Mon, 12 Feb 2007 15:47:51 -0300
Message-ID: <55c095e90702121047x1c66b098xbcf0d308195ff584@mail.gmail.com> (raw)
In-Reply-To: <45D0B565.9060402@archonet.com>
References: <55c095e90702120943v2909044eo91445b0eda3958c7@mail.gmail.com>
<1171302488.3565.15.camel@state.g2switchworks.com>
<55c095e90702121008u6d3d27c0m16e52d63f97c3e7d@mail.gmail.com>
<45D0B565.9060402@archonet.com>
2007/2/12, Richard Huxton <dev@archonet.com>:
>
> 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"
> isn't anything to do with locking - clients should still be able to log
> in.
>
> We'll need more details:
> 1. How do you know this is a deadlock? You haven't shown us what's in
> pg_locks, but I assume you've identified the problem there.
I knew becouse my Delphi application reports it to me. If there is anything
in pg_log I could see it to you.
2. What data are you loading, to what tables?
Simple data but allways with the same username (does it make any difference
?)
3. Are there any foreign-keys or triggers we would need to know about?
No.
Ps: When I do not use transactions the connections does not lock to other
users.
> --
> Richard Huxton
> Archonet Ltd
>
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Atenciosamente (Sincerely)
Ezequias Rodrigues da Rocha
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A pior das democracias ainda é melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ezequias.rocha@gmail.com, dev@archonet.com, smarlowe@g2switchworks.com, pgsql-admin@postgresql.org
Subject: Re: [SQL] Deadlock on transaction
In-Reply-To: <55c095e90702121047x1c66b098xbcf0d308195ff584@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox