drop view stalled during pg_dump
Hi guys,
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.
Cheers,
--
SeattleServer.com Mailing Lists - Casey Allen Shobe
lists@seattleserver.com - http://seattleserver.com
"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