Re: begin transaction locks out other connections

Поиск
Список
Период
Сортировка
От Pavan Deolasee
Тема Re: begin transaction locks out other connections
Дата
Msg-id 2e78013d0804100740r2dc36952s4255437a09ea9579@mail.gmail.com
обсуждение исходный текст
Ответ на Re: begin transaction locks out other connections  (Ivano Luberti <luberti@archicoop.it>)
Ответы Re: begin transaction locks out other connections  ("Dennis Brakhane" <brakhane@googlemail.com>)
Список pgsql-general
On Thu, Apr 10, 2008 at 7:18 PM, Ivano Luberti <luberti@archicoop.it> wrote:

>  Anyway I am a little surprised by this thing cause I thought that in a case
> like this the habgs should happen only at commit/rollback time.
>

I think that's because Postgres does not have deferred constraint checks.
They are checked at the execution time, instead of commit time.

Thanks,
Pavan

--
Pavan Deolasee
EnterpriseDB http://www.enterprisedb.com

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

Предыдущее
От: Stefan Schwarzer
Дата:
Сообщение: Proper Installation of Postgres and Postgis on 10.5 Intel
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pl/java on Solaris