Re: begin transaction locks out other connections

Ivano Luberti wrote:
> On client1 we execute
>
> begin;
> insert into table1
>
> and a message of correct execution for both statements is returned
>
> On client2 we execute
>
> begin;
> insert into table2
>
> and the client receives a correct execution message for the begin stmt
> but waits for the insert statement until client1 execute either a commit
> or a rollback.

These aren't valid statements, so you can't be getting a "success"
message. You're going to have to give details of what you're doing if
you want someone to tell you what is being locked and why.

--
   Richard Huxton
   Archonet Ltd