Re: INSERT/SELECT and excessive foreign key checks

Поиск
Список
Период
Сортировка
От Lodewijk Vöge
Тема Re: INSERT/SELECT and excessive foreign key checks
Дата
Msg-id FF90C38D-0939-4C55-B73C-67516051D5E6@gmail.com
обсуждение исходный текст
Ответ на Re: INSERT/SELECT and excessive foreign key checks  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: INSERT/SELECT and excessive foreign key checks
Список pgsql-hackers
On 19-aug-2007, at 12:38, Tom Lane wrote:

> An additional problem with your proposal is that it fails to consider
> other changes that might be happening concurrently -- eg, what if some
> other backend deletes a source row after you copy it, and commits  
> before
> you do?

then the patch indeed failed, but when I change it to check those  
carried over FKs also once, it catches it correctly.

are there other such issues? or is this kind of optimization not  
going in no matter what?

Lodewijk


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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: 8.3 beta testing suggestions welcome
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: tsearch2 patch status report