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 (AT) seattleserver (DOT) com - http://seattleserver.com

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

"SeattleServer.com" <lists (AT) seattleserver (DOT) com> writes:
Please reproduce this and look into pg_locks to see exactly what it's
blocking on.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly