Re: Drop database / database in use question

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@gmail.com> wrote:
> On Fri, Oct 17, 2008 at 8:11 AM, Dan Armbrust
> <daniel.armbrust.list@gmail.com> 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;
>