Craig Vosburgh <craig(dot)vosburgh(at)cassatt(dot)com> writes:
> Second, any words of wisdom to help run to ground who's keeping me from
> getting the lock on the offending row? The row in the lock table that shows
> granted false does not show as belonging to a database or relation (both
> null) so I can't join through to get the table info from pg_table.
What's the locktype? If (as I suspect) it's a transaction or
virtualtransaction lock, then which process holds that lock and what's
it doing? For that matter, what is the stuck process doing?
pg_stat_activity output should be sufficient here.
regards, tom lane