pg_locks - awesome - I will check it out... I think it's uncommitted transactions that are causing the problem. The original code was written very transactionaly. Alex Turner netEconomist On Fri, 11 Feb 2005 14:20:32 -0700, Michael Fuhr <mike@xxxxxxxx> wrote: > 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/ > > ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
