From: | Markus Wagner <wagner(at)imbei(dot)uni-mainz(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | row-level locking |
Date: | 2003-04-01 11:36:41 |
Message-ID: | 200304011336.41155.wagner@imbei.uni-mainz.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-odbc |
Hi,
we need to prevent write access for a single row of a table for a short time.
We found a short description for the "SELECT FOR UPDATE" statement:
"perform exclusive locking of selected rows"
Now my question: Is this a good method for our purpose?
Assuming that we lock our row with
"SELECT FOR UPDATE FROM <table> WHERE <our condition>",
how can we unlock it later?
Do we have to put the whole thing in a transaction (which may be tricky from
within a VB-Application...)?
Thanks a lot,
Markus
From | Date | Subject | |
---|---|---|---|
Next Message | Markus Wagner | 2003-04-01 12:34:36 | Re: row-level locking |
Previous Message | Nigel J. Andrews | 2003-04-01 11:36:23 | Re: row-level locking |
From | Date | Subject | |
---|---|---|---|
Next Message | Markus Wagner | 2003-04-01 12:34:36 | Re: row-level locking |
Previous Message | Nigel J. Andrews | 2003-04-01 11:36:23 | Re: row-level locking |