Thread: drop view not possible to select from pg_view

drop view not possible to select from pg_view

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

Sponsor:
I gioielli più nuovi, le collezioni più trendy, le trovi solo su Gioie.it!
Clicca qui

Re: drop view not possible to select from pg_view

From
Tom Lane
Date:
"=?utf-8?Q?frank=5Flupo?=" <frank_lupo@email.it> writes:
> When drop view and i do not send commit or rollback is not possible to sele=
> ct from other user on pg_view. The selection is lock. =0D

The only thing that's locked is computing the "definition" field for the
view you are currently altering (read dropping).  I see no way to avoid
that, nor any really strong reason to worry about it.  Access to a table
that you're currently dropping is locked, too.

            regards, tom lane