Re: Guarenteeing complex referencial integrity through custom triggers

Поиск
Список
Период
Сортировка
От Hannu Krosing
Тема Re: Guarenteeing complex referencial integrity through custom triggers
Дата
Msg-id 1175003097.3701.33.camel@localhost.localdomain
обсуждение исходный текст
Ответ на Guarenteeing complex referencial integrity through custom triggers  ("Joris Dobbelsteen" <Joris@familiedobbelsteen.nl>)
Список pgsql-hackers
Ühel kenal päeval, E, 2007-03-26 kell 16:05, kirjutas Joris Dobbelsteen:

> Oracle has choosen to allow constraint enforcement by locking on the
> parent tuple. In contrast postgres has chosen (historically, see RI
> triggers) to fail on detecting conflicting newly inserted rows (the
> cross-check).

Could you give an example, where postgresql fails to detect conflicting
newly inserted rows ?

-- 
----------------
Hannu Krosing
Database Architect
Skype Technologies OÜ
Akadeemia tee 21 F, Tallinn, 12618, Estonia

Skype me:  callto:hkrosing
Get Skype for free:  http://www.skype.com




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

Предыдущее
От: Gregory Stark
Дата:
Сообщение: Re: Concurrent connections in psql
Следующее
От: Tom Lane
Дата:
Сообщение: Re: notification payloads