Re: strange (maybe) behaviour of table lock

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Edoardo Panfili <edoardo(at)aspix(dot)it>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: strange (maybe) behaviour of table lock
Date: 2006-12-08 19:22:38
Message-ID: 21436.1165605758@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Edoardo Panfili <edoardo(at)aspix(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2006-12-08 19:25:00 Re: strange (maybe) behaviour of table lock
Previous Message Edoardo Panfili 2006-12-08 19:16:08 Re: strange (maybe) behaviour of table lock