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 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
