Francisco Reyes <[EMAIL PROTECTED]> writes:
> The two records I always see are:
>locktype|| mode | granted
> ---++-+-
> transactionid || ExclusiveLock | t
> relation || AccessShareLock | t
That would be your own transa
Chris writes:
SELECT * from pg_locks ;
And this is per DB right?
No, this is per system.
On a DB doing no/little work I always see two records returned. One has a
value in the 'database' column. How can I find what database it is?
Looking for it in pg_database did not yield any databases
