Re: concurrency control docs error

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Neil Conway <neilc(at)samurai(dot)com>
Cc: pgsql-docs(at)postgresql(dot)org
Subject: Re: concurrency control docs error
Date: 2002-11-12 04:45:40
Message-ID: 200211120445.gAC4jeo29705@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Neil Conway 2002-11-12 05:12:19 Re: concurrency control docs error
Previous Message Neil Conway 2002-11-11 21:02:51 concurrency control docs error