Adam Kavan <akavan(at)cox(dot)net> writes:
> I looked into pg_locks and they are all waiting to get an exclusive
> lock on the same relation. Is there anyway for me to tell what this
> relation is?
To decipher the OIDs in pg_locks, join against pg_class.oid, or just do
select relname from pg_class where oid = nnnn;
> Does anyone know what it could be and how I can fix this
Look for the process that already has a lock on the same relation, and
find out what it's waiting for.
regards, tom lane
In response to
pgsql-general by date
|Next:||From: scott.marlowe||Date: 2003-07-30 14:25:31|
|Subject: Re: Basic questions before start|
|Previous:||From: Tim McAuley||Date: 2003-07-30 14:06:05|
|Subject: Re: Unused Indexes|