Re: foreign keys and RI triggers

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: foreign keys and RI triggers
Дата
Msg-id 20050526082805.A5582@megazone.bigpanda.com
обсуждение исходный текст
Ответ на Re: foreign keys and RI triggers  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Thu, 26 May 2005, Tom Lane wrote:

> Stephan Szabo <sszabo@megazone.bigpanda.com> writes:
> >> Okay, I can't think of cases even with triggers and the like where
> >> removing the check on equal valued rows would give appreciably different
> >> results, but I haven't thought too hard about it.
>
> > Err, except the case that Tom mentions in his message.
>
> But the check could incorporate the same transaction ID test already
> in use.  I think Neil is right that it'd be a win to apply the test
> before enqueueing the trigger instead of after.

Good point.  That would help in many cases anyway.



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: foreign keys and RI triggers
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: foreign keys and RI triggers