On Fri, Oct 17, 2008 at 8:28 AM, Dan Armbrust <[EMAIL PROTECTED]> wrote: > But there is no user2. I _know_ I am the only user of this database. > > So how can User 1 create a race condition by himself? > > Or is this something PostgreSQL is doing internally (like vacuum) ? > > Do I really just have to keep trying the DROP command N times in a > row, until it decides it wants to work? That really doesn't seem > right.
Could be autovac. Easiest way is to use psql -c to get a list of pids that are connected and kill the backends (just kill, not kill -9) then try to drop it again. loop through that every few seconds and it should work. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
