What does the column 'relation' in pg_locks key to (Is there any docs on the website for this?)
Alex On Fri, 11 Feb 2005 14:20:32 -0700, Michael Fuhr <[EMAIL PROTECTED]> 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 4: Don't 'kill -9' the postmaster
