In http://wiki.postgresql.org/wiki/Lock_Monitoring, in the third codesnippet, "pg_locks.transaction" should be "pg_locks.transactionid".
Cheers,Bill SmithAustin, TX