Francisco Reyes wrote:
Chris writes:Is there a way to tell what tables have locks on them?SELECT * from pg_locks ;(version 7.4 and above at least, don't have an install earlier than that).And this is per DB right?
No, this is per system.Not sure how it works with permissions (eg if you have access to one db but not another does it still show?) but as a superuser, it will show all locks across the whole system.
-- Postgresql & php tutorials http://www.designmagick.com/
