Re: please help - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: please help
Date
Msg-id Pine.LNX.4.30.0104091759030.1255-100000@peter.localdomain
Whole thread Raw
In response to Re: please help  (Cedar Cox <cedarc@visionforisrael.com>)
List pgsql-sql
Cedar Cox writes:

> It would be somewhat (very) useful to have something like this.  We were
> toying with the idea of making some sort of system to figure out if a
> table is locked or not.

This will probably introduce race conditions unless done very carefully.
In theory you need a second level of locks to protect the information you
obtained regarding the "real" locks.  I'm not saying it's impossible, but
20 years ago people were writing Ph.D. theses about these sort of things.

-- 
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/



pgsql-sql by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Casting numeric to text
Next
From: "Ross J. Reedstrom"
Date:
Subject: Re: Casting numeric to text