On Fri, Feb 11, 2005 at 04:05:03PM -0500, Alex Turner wrote:
>
> I am now having trouble with psycopg locking up my database somehow.
> It's almost like there are outstanding locks on objects in the database
> that are preventing other threads operating.
Do you mean the Python script itself is locked up, or just that
locks in the database are causing certain transactions to block?
Have you looked at pg_locks? Are locks being held by idle uncommitted
transactions?
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/