On Tuesday 03 March 2009, Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com> wrote:
> HI. I made a small alteration to a table (added a column).
>
> Now when I do:
>
> vacuum analyze TABLENAME
>
> or
>
> delete from TABLENAME where id = 99
>
> Nothing happens! The carriage return means the my shell cursor goes to
> the next line, but it just stays there. I thought something may be
> happening silently but it has been sitting this way since an hour.
>
> How can I debug this? Nothing in the logs at all.
commit the transaction where you altered the table. It has an open lock on
the table.
--
Even a sixth-grader can figure out that you can’t borrow money to pay off
your debt