Marc <pgsql-general(at)mbreslow(dot)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