| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | Sabin Coanda <sabin(dot)coanda(at)deuromedia(dot)ro> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: undefined relations in pg_locks |
| Date: | 2008-02-06 14:01:43 |
| Message-ID: | 47A9BDC7.8090000@lelarge.info |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Sabin Coanda wrote:
> Hi there,
>
> I have a procedure where a dead-lock occurs, and I'm trying to find the
> tables involved in the lock.
>
> Unfortunatelly, I don't find the related objects of the oids of "relation"
> field. Also all the fields "classid" and "objid" are null.
>
> May I suppose there were references to temporary objects ?
> However, how cand I get the related objects involved in this lock ?
>
Maybe they're not objects of the database you're connected to. You need
to check the "database" column of pg_locks.
Regards.
--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | TJ O'Donnell | 2008-02-06 19:40:30 | Create Table xtest (like xtype) |
| Previous Message | Sabin Coanda | 2008-02-06 13:36:26 | undefined relations in pg_locks |