Re: Inheritance and such

From: Daniel Schuchardt <daniel_schuchardt(at)web(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Inheritance and such
Date: 2005-04-03 20:43:20
Message-ID: d2pkgm$1n1s$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Stephane Bortzmeyer schrieb:

>
>I have a problem which MAY be in the same category.
>
>CREATE TABLE base (
> id serial not null primary key,
> <some base columns>
>);
>
>CREATE TABLE specialized (
><some specialized columns>
>) INHERITS base;
>
>Now, I try to set up a trigger AFTER UPDATE ON base but, when I update
>"specialized", the trigger is not called. Same thing with CREATE or
>DELETE. I have to define the trigger to be AFTER UPDATE ON
>specialized. Is it normal?
>
>
>
Yes, thats known.

You have to define a trigger on each child table. You can point that
trigger on the same function.

Daniel.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Karl O. Pinc 2005-04-03 21:05:37 Strange plpgsql performance -- arithmetic, numeric() type, arrays
Previous Message Stephane Bortzmeyer 2005-04-03 20:12:45 Re: Inheritance and such