Re: Locking confusion - Mailing list pgsql-general

From Tom Lane
Subject Re: Locking confusion
Date
Msg-id 9067.1146619974@sss.pgh.pa.us
Whole thread Raw
In response to Locking confusion  (David J N Begley <d.begley@uws.edu.au>)
Responses Re: Locking confusion  (David J N Begley <d.begley@uws.edu.au>)
List pgsql-general
David J N Begley <d.begley@uws.edu.au> writes:
> My apologies for what may be an obvious answer to others but the documentation
> (for v8.1) leaves me concerned (enough not to trust "expected behaviour" of
> some commands).

You're confusing table-level locks with row-level locks.  They are
entirely independent beasts.  The names of the table-level lock modes
are rather unfortunately chosen, I think.

            regards, tom lane

pgsql-general by date:

Previous
From: David J N Begley
Date:
Subject: Locking confusion
Next
From: Don Y
Date:
Subject: Re: Calling V1 function from within the server