Marc Munro <marc(at)bloodnok(dot)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