"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