Tom Lane wrote:
>"Eric Freeman" <ejf7(at)hotmail(dot)com> writes:
>
>
>>I started the drop table command yesterday and it's been running for almost
>>24 hours.
>>
>>
>
>You're stuck in some kind of infinite loop --- there's no way that DROP
>should take any noticeable amount of time. I'm guessing that the system
>catalog entries for this particular table are corrupted somehow, but no
>idea just how. It would be worth trying to track it down in case there
>is a PG bug lurking.
>
>Can you attach to the looping backend with a debugger and get a stack
>trace for us?
>
>
Is there any possibility that he's got an open transacation sitting out
there for days holding a lock on that table?
Mike Mascari