Re: PostgreSQL 7.4.2 allows foreign key violation

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: PostgreSQL 7.4.2 allows foreign key violation
Дата
Msg-id 20652.1091813003@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: PostgreSQL 7.4.2 allows foreign key violation  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Ответы Re: PostgreSQL 7.4.2 allows foreign key violation  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Re: PostgreSQL 7.4.2 allows foreign key violation  (Jan Wieck <JanWieck@Yahoo.com>)
Список pgsql-general
Stephan Szabo <sszabo@megazone.bigpanda.com> writes:
> On Fri, 6 Aug 2004, Tom Lane wrote:
>> Already does what?  I see nothing in there that would override either
>> triggers or rules...

> It's not for overriding the triggers or rules, but instead checking that
> the post action state is valid (by running the no action code which
> makes sure that either another row now has the pk value or that there are
> no longer any matching rows).

Oh, I see.  Seems an awfully expensive solution though :-(

            regards, tom lane

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

Предыдущее
От: ruben
Дата:
Сообщение: Re: Slow after VACUUM, fast after DROP-CREATE INDEX
Следующее
От: Daniel S
Дата:
Сообщение: Re: New to Postgres