Skip site navigation (1) Skip section navigation (2)

Re: Checking if a table locked from pl/pgsql

From: Jan Wieck <janwieck(at)yahoo(dot)com>
To: Jose Luis LG <jlopezgonz(at)terra(dot)es>
Cc: "'PostgreSQL-interfaces'" <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: Checking if a table locked from pl/pgsql
Date: 2002-03-25 18:44:11
Message-ID: (view raw or whole thread)
Lists: pgsql-interfaces
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



# 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 address at

In response to


pgsql-interfaces by date

Next:From: Jeroen T. VermeulenDate: 2002-03-26 00:24:02
Subject: libpqxx has HTML docs
Previous:From: Bernhard HerzogDate: 2002-03-25 13:36:52
Subject: Re: Problem with python compile

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group