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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Robb Shecter <robb(at)acm(dot)org>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: All ops on one particular table cause a hang?
Date: 2004-09-19 21:37:10
Message-ID: 28913.1095629830@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Robb Shecter <robb(at)acm(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Robb Shecter 2004-09-19 21:55:16 Re: All ops on one particular table cause a hang?
Previous Message Robb Shecter 2004-09-19 21:16:31 All ops on one particular table cause a hang?