Re: Python Driver

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: alex(at)neteconomist(dot)com
Cc: James Thompson <jamest(at)ajrs(dot)com>, PgSQL General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Python Driver
Date: 2005-02-11 21:20:32
Message-ID: 20050211212032.GA33323@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alex Turner 2005-02-11 21:24:17 Re: Python Driver
Previous Message Alex Turner 2005-02-11 21:15:36 Error from database