Re: Drop database / database in use question

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Drop database / database in use question
Дата
Msg-id dcc563d10810170724o13ec9611g5b0dcc857c845111@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Drop database / database in use question  ("Dan Armbrust" <daniel.armbrust.list@gmail.com>)
Ответы Re: Drop database / database in use question  ("Dan Armbrust" <daniel.armbrust.list@gmail.com>)
Список pgsql-general
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;

В списке pgsql-general по дате отправления:

Предыдущее
От: Martin Gainty
Дата:
Сообщение: Re: Annoying Reply-To
Следующее
От: "Andrus"
Дата:
Сообщение: Re: OR or IN ?