Re: drop view not possible to select from pg_view

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: frank_lupo <frank_lupo(at)email(dot)it>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: drop view not possible to select from pg_view
Date: 2003-01-24 21:21:11
Message-ID: 22789.1043443271@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"=?utf-8?Q?frank=5Flupo?=" <frank_lupo(at)email(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-01-24 21:26:10 Re: drop table problem
Previous Message Greg Sabino Mullane 2003-01-24 21:11:23 Searchable 7.3.1 Documentation - now interactive!