>>> 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 with a matching
number. The number in the 'database' column did not match any number of the
columns in pg_database.
The two records I always see are:
locktype |....| mode | granted
transactionid |....| ExclusiveLock | t
relation |....| AccessShareLock | t
In response to
pgsql-general by date
|Next:||From: Tom Lane||Date: 2006-05-30 16:15:38|
|Subject: Re: Seeing locks (was Status of gist locking in 8.1.3) |
|Previous:||From: SCassidy||Date: 2006-05-30 16:05:42|
|Subject: Re: UTF-8 context of BYTEA datatype??|