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
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 |