public inbox for [email protected]
help / color / mirror / Atom feedconcurrency control docs error
4+ messages / 3 participants
[nested] [flat]
* concurrency control docs error
@ 2002-11-11 21:02 Neil Conway <[email protected]>
2002-11-12 04:45 ` Re: concurrency control docs error Bruce Momjian <[email protected]>
0 siblings, 1 reply; 4+ messages in thread
From: Neil Conway @ 2002-11-11 21:02 UTC (permalink / raw)
To: pgsql-docs
The docs on concurrency control & deadlocks (User's Guide, 9.3.3, CVS
docs) state the following:
Use of explicit locking can cause deadlocks, wherein two (or more)
transactions each hold locks that the other wants.
This isn't completely true, as deadlocks can occur in applications
that don't use explicit 'LOCK' statements.
Can someone suggest a better way to phrase the intent of that
statement?
Cheers,
Neil
--
Neil Conway <[email protected]> || PGP Key ID: DB3C29FC
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: concurrency control docs error
2002-11-11 21:02 concurrency control docs error Neil Conway <[email protected]>
@ 2002-11-12 04:45 ` Bruce Momjian <[email protected]>
2002-11-12 05:12 ` Re: concurrency control docs error Neil Conway <[email protected]>
0 siblings, 1 reply; 4+ messages in thread
From: Bruce Momjian @ 2002-11-12 04:45 UTC (permalink / raw)
To: Neil Conway <[email protected]>; +Cc: pgsql-docs
Neil Conway wrote:
> The docs on concurrency control & deadlocks (User's Guide, 9.3.3, CVS
> docs) state the following:
>
> Use of explicit locking can cause deadlocks, wherein two (or more)
> transactions each hold locks that the other wants.
>
> This isn't completely true, as deadlocks can occur in applications
> that don't use explicit 'LOCK' statements.
>
> Can someone suggest a better way to phrase the intent of that
> statement?
But it isn't saying there aren't other deadlock cases, just that
explicit locks tend to cause them more frequently. You can add "Often"
to the front of the sentence.
--
Bruce Momjian | http://candle.pha.pa.us
[email protected] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: concurrency control docs error
2002-11-11 21:02 concurrency control docs error Neil Conway <[email protected]>
2002-11-12 04:45 ` Re: concurrency control docs error Bruce Momjian <[email protected]>
@ 2002-11-12 05:12 ` Neil Conway <[email protected]>
2002-11-12 05:47 ` Re: concurrency control docs error Thomas Lockhart <[email protected]>
0 siblings, 1 reply; 4+ messages in thread
From: Neil Conway @ 2002-11-12 05:12 UTC (permalink / raw)
To: Bruce Momjian <[email protected]>; +Cc: pgsql-docs
Bruce Momjian <[email protected]> writes:
> But it isn't saying there aren't other deadlock cases, just that
> explicit locks tend to cause them more frequently.
Well, it doesn't refer to "frequently", or "more often". It just says:
Doing x can lead to y.
While that statement doesn't imply anything about other things that
can lead to y, a lot of people will take that for granted --
especially if the docs don't mention anything else that might produce
y.
I'll write up something and send it to -patches...
Cheers,
Neil
--
Neil Conway <[email protected]> || PGP Key ID: DB3C29FC
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: concurrency control docs error
2002-11-11 21:02 concurrency control docs error Neil Conway <[email protected]>
2002-11-12 04:45 ` Re: concurrency control docs error Bruce Momjian <[email protected]>
2002-11-12 05:12 ` Re: concurrency control docs error Neil Conway <[email protected]>
@ 2002-11-12 05:47 ` Thomas Lockhart <[email protected]>
0 siblings, 0 replies; 4+ messages in thread
From: Thomas Lockhart @ 2002-11-12 05:47 UTC (permalink / raw)
To: Neil Conway <[email protected]>; +Cc: Bruce Momjian <[email protected]>; pgsql-docs
Try something like:
Explicit locks can increase the likelyhood of deadlock conditions...
- Thomas
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2002-11-12 05:47 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-11-11 21:02 concurrency control docs error Neil Conway <[email protected]>
2002-11-12 04:45 ` Bruce Momjian <[email protected]>
2002-11-12 05:12 ` Neil Conway <[email protected]>
2002-11-12 05:47 ` Thomas Lockhart <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox