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/