More FK patches

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема More FK patches
Дата
Msg-id 20011112181333.Q76772-200000@megazone23.bigpanda.com
обсуждение исходный текст
Ответы Re: More FK patches  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: More FK patches  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-patches
This patch should help fix cases with two separate fk constraints
in a row that happen to reference the same pk constraint with
an on update cascade and similar cases.  It now should detect
correctly that a pk row was added later after a delete or update
on a no action deferred fk and not incorrect error as well
as dropping a check on insert/update to the fk table if the
row we're being referred to no longer is valid (I'm using
HeapTupleSatisfiesItself because the comment implied it was
what I was looking for and it appears to work :) ).

I've got regression tests but I'm holding off on those until
we decide whether or not we're dropping the triggered data change
errors since a couple of the tests would hit that case and I'll
either change them or drop them if we're not dropping the error.

Вложения

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Possible patch to remove "triggered data change" support
Следующее
От: Tom Lane
Дата:
Сообщение: Re: More FK patches