I set autocommit =off.
When drop table and i do not send commit or rollback is possible to select from other user on pg_class or pg_tables.
When drop view and i do not send commit or rollback is not possible to select from other user on pg_view. The selection is lock.
For unlock selection on pg_view the user that dropped view have to send commit or rollback.
Bye !!
Frank Lupo (Wolf) !!
/\_ _/\
\ o o /
--ooo-----ooo---
--
Prendi GRATIS l'email universale che... risparmia: http://www.email.it/f
Sponsor:
I gioielli più nuovi, le collezioni più trendy, le trovi solo su Gioie.it!
Clicca qui: http://adv2.email.it/cgi-bin/foclick.cgi?mid=768&d=24-1