Lock Table

[Enzo Campanella]

Hello.

Let me know if you can know if a table is locked by a lock
Type:
Begin Work
Lock Table MySchema.MyTable IN ACCESS EXCLUSIVE MODE
....
Unlock Table or Commit

For example:
select * from islock(TableName)
Thanks
Enzo

Original Message:

Ciao.

Vorrei sapere se � possibile sapere se una tabella � bloccata da un Lock
del tipo:
Begin Work
Lock table MySchema.MyTable IN ACCESS EXCLUSIVE MODE
....
Unlock Table o Commit

per esempio:
select * from islock(tablename)

Grazie
Enzo

[Enzo Campanella]

Thanks to all.
I found the solution:

SELECT pg_class.relname, pg_database.datname, transactionid, pid, mode,
granted
FROM pg_locks, pg_class, pg_database
WHERE pg_locks.relation = pg_class.oid
AND pg_locks.database = pg_database.oid and relname='MyTable'

Enzo.