The mystery of concurrent access

Поиск
Список
Период
Сортировка
От P.V. Subramanian
Тема The mystery of concurrent access
Дата
Msg-id F249BGTuAyHsjCGvseE00012728@hotmail.com
обсуждение исходный текст
Ответы Re: The mystery of concurrent access
Re: The mystery of concurrent access
Список pgsql-novice
Hi all

I thought enough experimentation would reveal this mystery, but its very
confusing, so I'll ask.

When 2 processes/people are simultaneously working on a table

* does Postgres automatically enforce some sort of locking?
* do the changes made by process A become visible to process B immediately
(of course, the result of a SELECT wouldn't change dynamically, but suppose
process B did another SELECT, would it access process A's records?)

Thanks

PVS

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


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

Предыдущее
От: "P.V. Subramanian"
Дата:
Сообщение: How to find out that a record has been updated
Следующее
От: "P.V. Subramanian"
Дата:
Сообщение: Why has the trigger been launched