Re: 7.4Beta1 hang? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: 7.4Beta1 hang?
Date
Msg-id 11451.1060527952@sss.pgh.pa.us
Whole thread Raw
In response to Re: 7.4Beta1 hang?  (Robert Creager <Robert_Creager@LogicalChaos.org>)
List pgsql-hackers
Robert Creager <Robert_Creager@LogicalChaos.org> writes:
>> Could you supply the relation names corresponding to the relation OIDs
>> appearing in pg_locks, so we can be sure who's processing what?

> Sure, if you tell me how ;-)  I looked at the view definition and that didn't help me much...

select relname from pg_class where oid = 'whatever';

or if you still have the pg_locks data

select relname,pg_locks.* from pg_locks,pg_class where pg_class.oid = relation;
        regards, tom lane


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: getting confused parsing ACLITEMS...
Next
From: Robert Creager
Date:
Subject: Re: 7.4Beta1 hang?