Olá Jackson, Tente com a seguinte consulta em pg_locks:
SELECT usesysid,usename,relname FROM pg_stat_activity JOIN pg_locks ON pg_stat_activity.procpid=pg_locks.pid JOIN pg_class ON pg_locks.relation=pg_class.relfilenode WHERE relname NOT LIKE 'pg_%'; Espero ter ajudado. 2009/4/7 JotaComm <[email protected]> > Olá, > > Você poderia acessar a view pg_locks. > > 2009/4/7 JacksonWeber <[email protected]> > > >> Pessoal, >> >> Alguém poderia me ajudar fornecendo um SQL que mostrasse o pid do usuário >> conectado ao banco e que esteja com bloqueio de tabela impedindo que o >> restante dos usuários a use. >> -- >> View this message in context: >> http://www.nabble.com/SQL-para-ver-quem-est%C3%A1-bloqueando-tabela-tp22927509p22927509.html >> Sent from the PostgreSQL - Brasil mailing list archive at Nabble.com. >> >> _______________________________________________ >> pgbr-geral mailing list >> [email protected] >> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >> > > > []s > -- > JotaComm > http://jotacomm.wordpress.com > http://www.dextra.com.br/postgres > > _______________________________________________ > pgbr-geral mailing list > [email protected] > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral > > -- Matheus Ricardo Espanhol --------------------------------------- Dextra Sistemas http://www.dextra.com.br/postgres/
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
