Robert Creager <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to