Re: Checking if a table locked from pl/pgsql

In an operational sense, if a user is updating a table for some accounting
function then decides to go to lunch leaving the table locked.

--Hal.

===========================================================
Hal Davison Internet Petroleum Distribution
Davison Consulting LSE Linux V1.22
6850 Myakka Valley Tr PostgreSQL 7.03 - Sun Forte - JAVA
Sarasota, Florida 34241 Phone: (941) 921-6578
http://www.faams.net FAX: (941) 924-7135
===========================================================

On Mon, 25 Mar 2002, Jan Wieck wrote:

> Jose Luis LG wrote:
> > Hi,
> >
> > Could anybody tell me if it is posible to check if a if a table is being
> > locked from pl/pgsql functions.
>
> Yes, it is not.
>
> That you ask for such a functionality leads to the question,
> why can a lock exist long enough that you want to check at
> all?
>
>
> Jan
>
> --
>
> #======================================================================#
> # It's easier to get forgiveness for being wrong than for being right. #
> # Let's break this rule - forgive me. #
> #================================================== JanWieck(at)Yahoo(dot)com #
>
>
>
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>