Re: Hanging locks? - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Hanging locks?
Date
Msg-id 23479.1161612548@sss.pgh.pa.us
Whole thread Raw
In response to Hanging locks?  (Kresimir Tonkovic <z-el.tonkovic@chipoteka.hr>)
Responses Re: Hanging locks?  (Kresimir Tonkovic <z-el.tonkovic@chipoteka.hr>)
List pgsql-bugs
Kresimir Tonkovic <z-el.tonkovic@chipoteka.hr> writes:
> I have a situation regarding locks that nobody seems to own:

The only way pid can be null in a pg_locks entry is if the lock is held
by a prepared transaction.  See pg_prepared_xacts view.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Thomas H."
Date:
Subject: Re: BUG #2712: could not fsync segment: Permission denied
Next
From: Kresimir Tonkovic
Date:
Subject: Re: Hanging locks?