The following bug has been logged online:
Bug reference: 6145
Logged by: Gary Durbin
Email address: hacker(at)synchsource(dot)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.