The following bug has been logged online: Bug reference: 6145 Logged by: Gary Durbin Email address: hac...@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. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
