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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to