On Tuesday 03 March 2009, Phoenix Kiula <phoenix.ki...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
