| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Robert Creager <Robert_Creager(at)LogicalChaos(dot)org> |
| Cc: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: 7.4Beta1 hang? |
| Date: | 2003-08-10 15:05:52 |
| Message-ID: | 11451.1060527952@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Robert Creager <Robert_Creager(at)LogicalChaos(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Creager | 2003-08-10 15:08:14 | Re: 7.4Beta1 hang? |
| Previous Message | Andrew Dunstan | 2003-08-10 03:43:32 | Re: getting confused parsing ACLITEMS... |