Re: strange (maybe) behaviour of table lock - Mailing list pgsql-general

From Tom Lane
Subject Re: strange (maybe) behaviour of table lock
Date
Msg-id 21436.1165605758@sss.pgh.pa.us
Whole thread Raw
In response to Re: strange (maybe) behaviour of table lock  (Edoardo Panfili <edoardo@aspix.it>)
Responses Re: strange (maybe) behaviour of table lock  (Edoardo Panfili <edoardo@aspix.it>)
List pgsql-general
Edoardo Panfili <edoardo@aspix.it> writes:
> I spend many time to explain the bahaviour of the system:

> I some occasions the system use another connection to retrieve some
> information during the main connection. This explain the hangs but...
> why sometimes the system works.

> I do more tests.

Try turning on statement logging in the server.  Looking at the sequence
of SQL commands actually issued to the server by the different clients
would probably be informative.

            regards, tom lane

pgsql-general by date:

Previous
From: Edoardo Panfili
Date:
Subject: Re: strange (maybe) behaviour of table lock
Next
From: Scott Marlowe
Date:
Subject: Re: strange (maybe) behaviour of table lock