Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with locking
Search options questions only
not deleted
user 19079
A mechanism for managing concurrent access to shared data or resources by granting temporarily exclusive access to the processes requesting the lock.
8
votes
1
answer
2k
views
Does Microsoft SQL Server offer an Advisory Locks feature like Postgres?
In Postgres, the Advisory Locks feature provides for arbitrary application-defined locks to be administered centrally in the database server. These locks are not related to tables or rows or such.
Do …
- 11k
2
votes
0
answers
938
views
Does H2 Database support pessimistic locking?
Does the H2 Database support pessimistic locking?
If so, how does its use interact with H2’s MVCC implementation?
I'm not looking for advice on whether or not to use pessimistic locking. … I have a specific need to emulate the behavior of another database that defaults to row-level pessimistic locking. …
- 11k
5
votes
1
answer
4k
views
Limits of applock in MS SQL Server
Microsoft SQL Server offers an arbitrary application-defined locking mechanism through the sp-getapplock command and related commands. … I am implementing a pessimistic locking mechanism for the rows of many tables for a special-needs app. …
- 11k
10
votes
1
answer
13k
views
Exactly what error is returned by PostgreSQL `FOR UPDATE NOWAIT` when a selected row cannot ...
The PostgreSQL 9.4 documentation states that adding the NOWAIT option to a SELECT FOR UPDATE means an error is generated when a row cannot be locked:
To prevent the operation from waiting for othe …
- 11k