Marc Munro <marc@xxxxxxxxxxxx> 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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
