All ops on one particular table cause a hang?

[Robb Shecter]

I just created a table, but now cannot access it or even drop it. I can
access all the other tables in the database just fine. But any client
command or app (like pg_dumpall) that references this new table hang.

I looked through the docs and FAQ for a any mention of this, or a way to
repair or drop a table some other way, but can't find it.

Thanks for any ideas.
Robb

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Tom Lane]

Post by Robb Shecter
I just created a table, but now cannot access it or even drop it. I can
access all the other tables in the database just fine. But any client
command or app (like pg_dumpall) that references this new table hang.

Maybe you've got a session that is holding an exclusive lock on that
table?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Robb Shecter]

Post by Tom Lane
Maybe you've got a session that is holding an exclusive lock on that
table?

Yes - you are absolutely right. I had an application that did not
properly close its database connection...

Thanks!
Robb

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html