"Eric Freeman" <[EMAIL PROTECTED]> 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? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend