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/
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings