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: 200203251844.g2PIiCq21469@saturn.janwieck.net (view raw or flat)
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

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-2014 The PostgreSQL Global Development Group