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?

Any way to tell locks in all DBs?
In particular if planning to bounce back the DB would be nice to know if anyone had any locks open..


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to