Re: When is newly inserted data visible to another connection?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: When is newly inserted data visible to another connection?
Дата
Msg-id 18724.1282139008@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: When is newly inserted data visible to another connection?  ("fkater@googlemail.com" <fkater@googlemail.com>)
Список pgsql-general
"fkater@googlemail.com" <fkater@googlemail.com> writes:
> Thank you for the interesting link. I think, though, that
> this does not address the question why there is a delay
> between the point in time A that client 1 has successfully
> commited and the point in time B when client 2 can see all
> new rows!

There is no such delay.  Either you forgot to commit in client 1,
or client 2 had a query snapshot that was taken before client 1
committed.

            regards, tom lane

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

Предыдущее
От: "Igor Neyman"
Дата:
Сообщение: Re: Windows 2003 server installation issue
Следующее
От: Derrick Rice
Дата:
Сообщение: Warm Standby and resetting the primary as a standby