Re: drop view stalled during pg_dump - Mailing list pgsql-bugs

From Tom Lane
Subject Re: drop view stalled during pg_dump
Date
Msg-id 10038.1159903032@sss.pgh.pa.us
Whole thread Raw
In response to drop view stalled during pg_dump  ("SeattleServer.com" <lists@seattleserver.com>)
List pgsql-bugs
"SeattleServer.com" <lists@seattleserver.com> writes:
> I just tried to do a drop view and it sat there for ages.  I looked to see
> what else was going on and the only other thing of note was a COPY process
> being run as part of my daily backups (pg_dump).

> Why does this block drop view?  It seems as though it shouldn't.

Please reproduce this and look into pg_locks to see exactly what it's
blocking on.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "SeattleServer.com"
Date:
Subject: drop view stalled during pg_dump
Next
From: Stan Kaufman
Date:
Subject: error compiling 7.4.13 on OSX 10.4.8 -- Intel