"Thomas F. O'Connell" <[EMAIL PROTECTED]> writes:
> For instance, if a long SELECT were running against table_foo and an
> UPDATE arrived wanting to update table_foo, I would expect to see in
> pg_locks an entry corresponding to the SELECT with granted = true and
> an entry corresponding to the UPDATE with granted = false.
Why would you expect to see that exactly? SELECTs don't block UPDATEs.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
