Re: pid in pg_locks not present in procpid pg_stat_activity

From: frank_lupo <frank_lupo(at)email(dot)it>
To: tgl <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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 16:23:35
Message-ID: H9887B$EB2AA8ED4CE3967ADCF8C0FDC0106E26@email.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> "=?utf-8?Q?frank=5Flupo?=" 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
>

I have verified selecting more times from pg_locks and pg_stat_activity but he can be like you say .

tanks

Bye !!
Frank Lupo (Wolf) !!

/\_ _/\
\ o o /
--ooo-----ooo---

--
Prendi GRATIS l'email universale che... risparmia: http://www.email.it/f

Sponsor:
Quando hai bisogno di liquidità non devi spiegare per cosa. Conto Privilegiato è discreto.
Clicca qui: http://adv2.email.it/cgi-bin/foclick.cgi?mid=1240&d=24-1

Browse pgsql-general by date

  From Date Subject
Next Message frank_lupo 2003-01-24 16:35:14 drop view not possible to select from pg_view
Previous Message Justin Clift 2003-01-24 16:14:17 Re: More PHP DB abstraction layer stuff