"Robert Wille" <a2om6sy02@sneakemail.com> writes:
> Any idea how this could happen or how to track it down? Is there any way to
> look at what records are locked, and what caused them to be locked?
Update to PG 7.3, and see the pg_locks view. There is no very useful
way to see the locking state in earlier releases.
regards, tom lane