Re: Strange behavior: row won't delete

On Tuesday 03 March 2009, Phoenix Kiula <phoenix.kiula@gmail.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