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. Thanks, Dan On Fri, Oct 17, 2008 at 9:24 AM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote: > On Fri, Oct 17, 2008 at 8:11 AM, Dan Armbrust > <daniel.armbrust.list@xxxxxxxxx> wrote: >>> There are obvious race conditions in that assumption. Why don't you >>> just try the drop and see if it succeeds? >>> >>> regards, tom lane >>> >> >> I don't follow - why is there a race condition? I'm driving the >> commands into postgresql via the command line. > > User 1: select * from pg_stat_activity where datname='db123'; > User 2: psql db123 > User 1: drop database db123; > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
