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 <mike@fuhr.org> 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/
>
>