Thread: All ops on one particular table cause a hang?

All ops on one particular table cause a hang?

From
Robb Shecter
Date:
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

Re: All ops on one particular table cause a hang?

From
Tom Lane
Date:
Robb Shecter <robb@acm.org> writes:
> 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

Re: All ops on one particular table cause a hang?

From
Robb Shecter
Date:
Tom Lane wrote:

>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