Hi, My Database have a lot of locks not granted every moments in a day.
Can I create a view that returns someting like this ? User Granted Table Who_is_locking_me PID ---- ------- ----- ----------------- --- joe f foo frank 1212 jeff f foo frank 1313 ann f foo frank 1414 frank t foo 1111 (...) (Or the locked transactions, if the table cold't be retrived) pg_locks view does not give me WHO is locking... Best regards, Alexandre ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
