Re: Triggers on columns

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Triggers on columns
Дата
Msg-id 1255477112.10801.2.camel@vanquo.pezone.net
обсуждение исходный текст
Ответ на Re: Triggers on columns  (Peter Eisentraut <peter_e@gmx.net>)
Ответы Re: Triggers on columns
Re: Triggers on columns
Список pgsql-hackers
On Sat, 2009-10-10 at 00:04 +0300, Peter Eisentraut wrote:
> On Mon, 2009-09-14 at 18:58 +0900, Itagaki Takahiro wrote:
> > Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp> wrote:
> >
> > > Ok, the attached patch implements standard-compliant version of
> > > column trigger.
> >
> > Here is an updated version of column-level trigger patch.
> > I forgot to adjust pg_get_triggerdef() in the previous version.
> > pg_dump also uses pg_get_triggerdef() instead of building
> > CREATE TRIGGER statements to avoid duplicated codes if the
> > server version is 8.5 or later.
>
> I have committed the parts involving pg_get_triggerdef and pg_dump.  I
> will get to the actual column trigger functionality next.

Attached is a merged up patch with some slightly improved documentation.

I think the patch is almost ready now.  One remaining issue is, in
TriggerEnabled() you apparently check the column list only if it is a
row trigger.  But columns are supported for statement triggers as well
per SQL standard.  Check please.

Btw., I might not get a chance to commit this within the next 48 hours.
If someone else wants to, go ahead.

Вложения

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

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: Re: [GENERAL] contrib/plantuner - enable PostgreSQL planner hints
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Re: [GENERAL] contrib/plantuner - enable PostgreSQLplanner hints