Re: drop view not possible to select from pg_view - Mailing list pgsql-general

From Tom Lane
Subject Re: drop view not possible to select from pg_view
Date
Msg-id 22789.1043443271@sss.pgh.pa.us
Whole thread Raw
In response to drop view not possible to select from pg_view  ("frank_lupo" <frank_lupo@email.it>)
List pgsql-general
"=?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

pgsql-general by date:

Previous
From: Doug McNaught
Date:
Subject: Re: More PHP DB abstraction layer stuff
Next
From: "Greg Sabino Mullane"
Date:
Subject: Searchable 7.3.1 Documentation - now interactive!