"Thomas F. O'Connell" <tfo(at)sitening(dot)com> 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