<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Cory,<br>
It sounds like you are interested in detecting row-level locks. <br>
<br>
The system view pg_locks
(<a class="moz-txt-link-freetext" href="http://www.postgresql.org/docs/8.1/static/view-pg-locks.html">http://www.postgresql.org/docs/8.1/static/view-pg-locks.html</a>) might
give you a partial solution by identifying what tables currently have
locks on them. But there is the following caveat:<br>
<blockquote><tt>"Although tuples are a lockable type of object,
information about row-level locks is stored on disk, not in memory, and
therefore row-level locks normally do not appear in this view."</tt><br>
</blockquote>
Any other ideas anyone?<br>
-- Kevin<br>
<br>
<br>
Cory Horner wrote:
<blockquote cite="mid44BBEA9F.3000409@refractions.net" type="cite">Hi
Sandro et al,
<br>
<br>
We're currently working on eliminating some bugs in the geotools
postgis plugin, for use in uDig, etc. One problem we've encountered
has been concurrent modification of features. In geotools we keep a
transaction alive for some time, as the user tweaks features to their
heart's content. Unfortunately, when one user modifies a feature and
keeps the transaction open, a second user attempting to edit the same
feature will experience a lockup while they wait for the first user to
either commit or revert.
<br>
<br>
What i'm wondering is if there is a way to ask PostGIS (postgres) if a
feature is locked, or is lockable, so we may toss exceptions or
otherwise deny modification of a feature when it is not possible?
<br>
<br>
Thanks,
<br>
Cory.
<br>
_______________________________________________
<br>
postgis-devel mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:postgis-devel@postgis.refractions.net">postgis-devel@postgis.refractions.net</a>
<br>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-devel">http://postgis.refractions.net/mailman/listinfo/postgis-devel</a>
<br>
</blockquote>
</body>
</html>