Thread: BUG #6145: Drop View hangs on lock

The following bug has been logged online:

Bug reference:      6145
Logged by:          Gary Durbin
Email address:      hacker@synchsource.com
PostgreSQL version: 8.4
Operating system:   Linux
Description:        Drop View hangs on lock
Details:

Drop view tries to get an exclusive lock on a view.  If the view is in use
it waits.  But when the connection using the view ends the drop does not
continue.  The request for exclusive lock on the view does not show up in
the lock list.

We can cancel the transaction and rerun when the view is not in use and it
completes.

"Gary Durbin" <hacker@synchsource.com> writes:
> The following bug has been logged online:

> Bug reference:      6145
> Logged by:          Gary Durbin
> Email address:      hacker@synchsource.com
> PostgreSQL version: 8.4
> Operating system:   Linux
> Description:        Drop View hangs on lock
> Details:

> Drop view tries to get an exclusive lock on a view.  If the view is in use
> it waits.  But when the connection using the view ends the drop does not
> continue.  The request for exclusive lock on the view does not show up in
> the lock list.

Works as expected for me.  Perhaps you could provide a self-contained
example?  Also, "8.4" is by no means an adequate identification of the
PG version.

            regards, tom lane