Re: Mysterious locking problem - Mailing list pgsql-general

From Miguel Carvalho
Subject Re: Mysterious locking problem
Date
Msg-id 15559.193.136.62.21.1022006331.squirrel@www.ipatimup.up.pt
Whole thread Raw
In response to Re: Mysterious locking problem  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Responses Re: Mysterious locking problem
List pgsql-general
Hi,

thank's for reppling.

> Given your query things above I'm guessing you've turned on query
> printing?

  Query print is off, because that will startve may hardisk verry quickly.

>  Are the selects perhaps SELECT ... FOR UPDATE queries going

  I forgot to mention that the selects are plain selects( not select for
  update ).
> for the same rows in which case I think the second would wait on the
> first?

Can this be a PHP issue?
I have noticed the "locking", because the script line that executes the
query, doesnt ever return( until i stock the first query ).
Regards,
Miguel Carvalho



pgsql-general by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: Is Digest Mode Really Available?
Next
From: Stephan Szabo
Date:
Subject: Re: Mysterious locking problem