pid in pg_locks not present in procpid pg_stat_activity

From: frank_lupo <frank_lupo(at)email(dot)it>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: pid in pg_locks not present in procpid pg_stat_activity
Date: 2003-01-24 10:04:07
Message-ID: H97QMV$81EDEAD3554EEDC1EF23C0501C746B0C@email.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a problem to verify user to lock a object database. The corrspondence pid from pg_loks to pg_stat_activity not found.
pippo=# select * from pg_locks\g
relation | database | transaction | pid | mode | granted
----------+----------+-------------+------+---------------------+---------
1734991 | 16976 | | 500 | AccessExclusiveLock | t
17785 | 16976 | | 500 | AccessExclusiveLock | t
| | 19091 | 500 | ExclusiveLock | t
1735213 | 16976 | | 500 | AccessExclusiveLock | t
18209 | 16976 | | 500 | AccessExclusiveLock | t
1734989 | 16976 | | 500 | AccessExclusiveLock | t
| | 19290 | 1356 | ExclusiveLock | t
1734987 | 16976 | | 500 | AccessExclusiveLock | t
1734988 | 16976 | | 500 | AccessExclusiveLock | t
17
34986 |

16976 | | 500 | AccessExclusiveLock | t
1734990 | 16976 | | 500 | AccessExclusiveLock | t
16757 | 16976 | | 1356 | AccessShareLock | t
(12 rows)
pippo=# select * from pg_stat_activity\g
datid | datname | procpid | usesysid | usename | current_query
-------+---------+---------+----------+---------------+---------------
16976 | gedis30 | 1356 | 100 | Administrator |
Tanks

Bye !!
Frank Lupo (Wolf) !!

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

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

Sponsor:
Solo su Occhialeria.it una vastissima scelta a prezzi insuperabili!
Per te le migliori marche e un incredibile assortimento.
Clicca qui: http://adv2.email.it/cgi-bin/foclick.cgi?mid=880&d=24-1

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ivar 2003-01-24 11:29:16 Re: ??? Multiple selects in procedure
Previous Message Lincoln Yeoh 2003-01-24 09:47:14 Re: I was spoiled by the MySQL timestamp field