Re: Waiting for select

Marc Munro <marc@bloodnok.com> writes:
> Can someone explain this?  I seem to have a query which is being blocked
> by a lock.  I was under the impression that selects are never blocked.

AccessExclusiveLock blocks anything.

> A query of blocking locks shows this:

>           object           | trans | pid  |        mode         | blocker
> ---------------------------+-------+------+---------------------+---------
>  testdb.address_type       |       | 5754 | AccessExclusiveLock |
>  testdb.address_type       |       | 5987 | AccessShareLock     |    5754

So what's process 5754 doing?

            regards, tom lane