2011/9/12 Merlin Moncure <mmoncure@gmail.com>:
>
> It seems odd that you could not create a temp sequence but you were
> able to reindex the entire database. did you confirm you were
> blocking on a non-granted lock?
I could revacuum/reindex all stuff, only if I had to do the system
catalogues first. That seemed a bit suspicious.
Also, I had to stop all other connections - because any other locked
transaction would prevent it from going on.
Oh, the last thing - pg_cancel_backend() couldn't kill the locked
backend. I had to restart the whole postgresql using -m immediate.
Odd stuff indeed, as I was hoping postgresql will clean things like
locks on recovery from crash. Never happened to me with 8.3
--
GJ