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: 200203251844.g2PIiCq21469@saturn.janwieck.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
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
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

In response to

Responses

Browse pgsql-interfaces by date

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