Re: CREATE DATABASE/DROP DATABASE race conditions

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: CREATE DATABASE/DROP DATABASE race conditions
Дата
Msg-id 19429.1026666812@sss.pgh.pa.us
обсуждение исходный текст
Ответ на CREATE DATABASE/DROP DATABASE race conditions  (Florian Weimer <Weimer@CERT.Uni-Stuttgart.DE>)
Ответы Re: CREATE DATABASE/DROP DATABASE race conditions  (Florian Weimer <Weimer@CERT.Uni-Stuttgart.DE>)
Список pgsql-bugs
Florian Weimer <Weimer@CERT.Uni-Stuttgart.DE> writes:
> I'm observing weird behavior with CREATE DATABASE/DROP DATABASE and
> PostgreSQL 7.2.1 (on Debian/unstable): There seems to be a short time
> period after the 'Z' response of the backend during which the database
> continues to exist (e.g. subsequent CREATE DATABASE operations with
> the same name fail) or does not exist yet (e.g. it is not possible to
> connect to the database).

> You cannot reproduce this with "psql" or "createdb"/"dropdb".

I'm inclined to think it's a bug in your application coding, then.
psql certainly doesn't go out of its way to serialize operations.

Could we see a self-contained test case?

            regards, tom lane

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

Предыдущее
От: Florian Weimer
Дата:
Сообщение: CREATE DATABASE/DROP DATABASE race conditions
Следующее
От: Florian Weimer
Дата:
Сообщение: Re: CREATE DATABASE/DROP DATABASE race conditions