Re: pid in pg_locks not present in procpid pg_stat_activity

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: frank_lupo <frank_lupo(at)email(dot)it>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: pid in pg_locks not present in procpid pg_stat_activity
Date: 2003-01-24 15:39:41
Message-ID: 13372.1043422781@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"=?utf-8?Q?frank=5Flupo?=" <frank_lupo(at)email(dot)it> writes:
> I have a problem to verify user to lock a object database. The corrspondenc=
> e pid from pg_loks to pg_stat_activity not found.

Hm, you sure that PID 500 didn't simply quit between the time you
examined one table and the time you examined the other?

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jochem van Dieten 2003-01-24 15:51:19 Re: createlang and Schemas
Previous Message Ian Barwick 2003-01-24 15:39:40 OT: cvsweb (was: psql 7.3.1 crash)