How do I enable shared locking?
2007/1/25, Ken <[EMAIL PROTECTED]>:
From os_unix.h:... After reading this, locking makes more sense!
Although the Lock may physically be an exclusive lock, the
implementation is actually a logcially "SHARED" lock.
/* The following describes the
>From os_unix.h:... After reading this, locking makes more sense!
Although the Lock may physically be an exclusive lock, the
implementation is actually a logcially "SHARED" lock.
/* The following describes the implementation of the various locks and
** lock transitions in terms
* Jay Sprenkle <[EMAIL PROTECTED]> [2007-01-22 15:20]:
> My understanding was that a "shared lock" is a metaphor, and
> IMHO, a fairly stupid one. If you lock a room, nobody else can
> get in, it's not a mechanism for sharing, it's a mechanism for
> preventing sharing.
Reasoning by analogy rarely
* Jay Sprenkle <[EMAIL PROTECTED]> [2007-01-22 01:40]:
> This makes little sense. There are no 'shared' locks.
I’m not sure where you got this idea, but shared locks are an
OS-level concept in Unix. You cannot acquire a shared lock on a
file as long as there are exclusive locks on it, and you
Igor Tandetnik wrote:
What happens if you run a dummy SELECT statement, such as "select 1;",
right after a BEGIN? Would that acquire SHARED lock?
Igor Tandetnik
Unfortunately it doesn't appear like it does. I guess i could perform a
dummy select that need the db in the same exec as the
Andrew Teirney <[EMAIL PROTECTED]> wrote:
I was just wondering whether there might be any particular reason why
there doesn't appear to be support for creating transactions that
acquire a shared lock on execution of the BEGIN statement?
The reason why i ask this is that i try and perform all my
6 matches
Mail list logo