Thread: Re: pid in pg_locks not present in procpid pg_stat_activity

Re: pid in pg_locks not present in procpid pg_stat_activity

From
"frank_lupo"
Date:
> "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