Sorry... Long time not using pg_locks...
My function (on pid 20125) was running, pid 25743 requested an exclusive
lock and is waiting, and all others were waiting for this one.
2009/4/8 Daniel Cristian Cruz
> Hi all,
>
> I had a big function (the same one mentioned before) which is locking a
>
Daniel Cristian Cruz writes:
> sgn=# SELECT * FROM pg_locks WHERE relation = 1706665;
> locktype | database | relation | page | tuple | transactionid | classid |
> objid | objsubid | transaction | pid |mode | granted
> --+--+--+--+---+
Hi all,
I had a big function (the same one mentioned before) which is locking a
table, where it doesn't use the table for updates, just selects. (PostgreSQL
8.2)
My pg_locks had:
sgn=# SELECT * FROM pg_locks WHERE relation = 1706665;
locktype | database | relation | page | tuple | transactionid
