| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Gary Durbin" <hacker(at)synchsource(dot)com> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #6145: Drop View hangs on lock |
| Date: | 2011-08-03 18:31:01 |
| Message-ID: | 21017.1312396261@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
"Gary Durbin" <hacker(at)synchsource(dot)com> writes:
> 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.
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matthias Kurz | 2011-08-03 21:02:42 | BUG #6146: COLLATE in ORDER BY not working with column names defined with "AS" |
| Previous Message | Gary Durbin | 2011-08-03 17:07:51 | BUG #6145: Drop View hangs on lock |