Re: trigger inheritance

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: trigger inheritance
Дата
Msg-id 2862.994342412@sss.pgh.pa.us
обсуждение исходный текст
Ответ на trigger inheritance  (fcanedo@soneramail.nl)
Ответы Re: trigger inheritance  (David Wheeler <David@Wheeler.net>)
Список pgsql-general
fcanedo@soneramail.nl writes:
> In the reference manual (CREATE TABLE) it says "Postgres
> automatically allows the created table to inherit functions on tables
> above it in the inheritance hierarchy."

> Since functions don't belong to tables (correct me if I'm wrong)

Okay, you're wrong.

What that sentence is referring to is the fact that functions declared
as taking table row types can be applied to rows of derived tables as
well as the one they were originally declared against.  (I'm not sure
how well this actually works in cases involving multiple inheritance
or ALTER TABLE, but in simple cases it should be OK.)

Triggers and indexes are not inherited.  Yes, that's probably a bug.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Trigger with current user
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [PATCH] Partial indicies done