Re: pid in pg_locks not present in procpid pg_stat_activity - Mailing list pgsql-general

From frank_lupo
Subject Re: pid in pg_locks not present in procpid pg_stat_activity
Date
Msg-id H9887B$EB2AA8ED4CE3967ADCF8C0FDC0106E26@email.it
Whole thread Raw
List pgsql-general
> "frank_lupo"  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 0 ABye !! Frank Lupo (Wolf) !! /\_ _/\ \ o o / --ooo-----ooo---

----
Prendi GRATIS l'email universale che... risparmia: clicca qui

Sponsor:
Quando hai bisogno di liquidità non devi spiegare per cosa. Conto Privilegiato è discreto.
Clicca qui

pgsql-general by date:

Previous
From: Justin Clift
Date:
Subject: Re: More PHP DB abstraction layer stuff
Next
From: "frank_lupo"
Date:
Subject: drop view not possible to select from pg_view