Re: Exclusive Locks Taken on User Tables? - Mailing list pgsql-general

From Tom Lane
Subject Re: Exclusive Locks Taken on User Tables?
Date
Msg-id 29826.1194382781@sss.pgh.pa.us
Whole thread Raw
In response to Re: Exclusive Locks Taken on User Tables?  (Marc <pgsql-general@mbreslow.net>)
List pgsql-general
Marc <pgsql-general@mbreslow.net> writes:
> My original reason for reaching out to the list was over confusion as to
> when an EXCLUSIVE lock would be taken table level since the documentation
> says this should never happen except to some system catalogs.  Is there
> something missing from the documentation?

It's not a lock on a table, as you would soon find out if you were
paying attention to more columns of the pg_locks view.  It's a lock
on a row.

            regards, tom lane

pgsql-general by date:

Previous
From: Marc
Date:
Subject: Re: Exclusive Locks Taken on User Tables?
Next
From: Reg Me Please
Date:
Subject: Re: Syntax error in a large COPY