Re: BUG #6145: Drop View hangs on lock - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #6145: Drop View hangs on lock
Date
Msg-id 21017.1312396261@sss.pgh.pa.us
Whole thread Raw
In response to BUG #6145: Drop View hangs on lock  ("Gary Durbin" <hacker@synchsource.com>)
List pgsql-bugs
"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

pgsql-bugs by date:

Previous
From: "Gary Durbin"
Date:
Subject: BUG #6145: Drop View hangs on lock
Next
From: "Matthias Kurz"
Date:
Subject: BUG #6146: COLLATE in ORDER BY not working with column names defined with "AS"