From 5deaad233aecf7fd44c958c29fec57229c07c625 Mon Sep 17 00:00:00 2001 From: Regina Obe Date: Tue, 2 Dec 2008 20:00:31 +0000 Subject: [PATCH] Move over LockRow git-svn-id: http://svn.osgeo.org/postgis/trunk@3355 b70326c6-7e19-0410-871a-916f4a2858ee --- doc/reference.xml | 14 ------- doc/reference_new.xml | 87 +++++++++++++++++++++++++++++++++++++++++++ 2 files changed, 87 insertions(+), 14 deletions(-) diff --git a/doc/reference.xml b/doc/reference.xml index d7160762f..8e7b33794 100644 --- a/doc/reference.xml +++ b/doc/reference.xml @@ -507,20 +507,6 @@ - - LockRow([<schema>], <table>, <rowid>, - <authid>, [<expires>]) - - - Set lock/authorization for specific row in table - <authid> is a text value, <expires> is a timestamp - defaulting to now()+1hour. Returns 1 if lock has been assigned, 0 - otherwise (already locked by other auth) - - Availability: 1.1.3 - - - UnlockRows(<authid>) diff --git a/doc/reference_new.xml b/doc/reference_new.xml index a9252f46f..fe1c47b64 100644 --- a/doc/reference_new.xml +++ b/doc/reference_new.xml @@ -11331,6 +11331,93 @@ Long transactions support enabled + + + LockRow([<schema>], <table>, <rowid>, + <authid>, [<expires>]) + + + Set lock/authorization for specific row in table + <authid> is a text value, <expires> is a timestamp + defaulting to now()+1hour. Returns 1 if lock has been assigned, 0 + otherwise (already locked by other auth). + + Availability: 1.1.3 + + + + + + LockRow + + Set lock/authorization for specific row in table + + + + + + integer LockRow + text a_schema_name + text a_table_name + text a_row_key + text an_auth_token + timestamp expire_dt + + + + integer LockRow + text a_table_name + text a_row_key + text an_auth_token + timestamp expire_dt + + + + integer LockRow + text a_table_name + text a_row_key + text an_auth_token + + + + + + + Description + + Set lock/authorization for specific row in table + <authid> is a text value, <expires> is a timestamp + defaulting to now()+1hour. Returns 1 if lock has been assigned, 0 + otherwise (already locked by other auth) + + Availability: 1.1.3 + + + + + Examples + + SELECT LockRow('public', 'towns', '2', 'joey'); +LockRow +------- +1 + +--Joey has already locked the record and Priscilla is out of luck +SELECT LockRow('public', 'towns', '2', 'priscilla'); +LockRow +------- +0 + + + + + + + See Also + + + + -- 2.49.0