Re: Trigger on VIEW not firing

Massimo,

You need to Insert a record into View to get that trigger fired, since you
have created trigger on View not table.

>postgres=# insert into worksub values(1,'test','test');
NOTICE: UPDATE VIEW FROM: worksub OPERATION: INSERT
ERROR: control reached end of trigger procedure without RETURN
CONTEXT: PL/pgSQL function wrk_view()

Hope this helps.

On Tue, Jul 30, 2013 at 5:57 PM, Massimo Costantini <
massimo(dot)costantini(at)gmail(dot)com> wrote:

> Hi,
>
> I have a problem with Triggers on VIEW:
>
> suppose I have:
>
> CREATE TABLE work (
> id integer NOT NULL,
> work TEXT,
> worktype TEXT
> );
>
> CREATE VIEW worksub AS SELECT FROM work WHERE worktype='subordinate';
>
>
> CREATE OR REPLACE FUNCTION wrk_view() RETURNS TRIGGER AS $wrk_tg$
> BEGIN
> RAISE NOTICE 'UPDATE VIEW FROM: % OPERATION: %',TG_TABLE_NAME,
> TG_OP;
> END;
> $wrk_tg$ LANGUAGE plpgsql;
>
> CREATE TRIGGER wrk_tg INSTEAD OF INSERT OR DELETE OR UPDATE ON worksub
> FOR EACH ROW EXECUTE PROCEDURE wrk_view();
>
> nothing appen when I insert row in work table.
>
> Someone can help me?
>

--
Thanks & Regards,
Ashutosh.Durugkar
Database Admin Oracle & PostgreSQL
Cell- +919960937294