Re: RI triggers and schemas

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: RI triggers and schemas
Дата
Msg-id 5804.1017685952@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: RI triggers and schemas  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
I said:
> The table OIDs in pg_trigger would do fine if the trigger function could
> get at them, but it can't; so we need to copy them into the trigger
> arguments.  (Hmm, I suppose another option is to extend the Trigger
> data structure to include tgconstrrelid, and just ignore the table names
> in the trigger argument list.)

After further thought, this is clearly the right approach to take,
because it provides a solution path for other triggers besides the RI
ones.  So we'll fix the problem at the code level.  The trigger
arguments will be unchanged, but the table names therein will become
purely decorative (or documentation, if you prefer ;-)).  Perhaps
someday we could eliminate them ... but not as long as pg_dump dumps
RI constraints in the form of trigger definitions.
        regards, tom lane


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

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