Re: Can I create working trigger on view - Mailing list pgsql-sql

From Josh Berkus
Subject Re: Can I create working trigger on view
Date
Msg-id web-1790713@davinci.ethosmedia.com
Whole thread Raw
In response to Can I create working trigger on view  (Акулов Александр <akulov@ien.ru>)
List pgsql-sql
Acue,

> Can I create working trigger on view?
> 
> The problem is:
>   I need a plpgsql function that execute on insert (or update,
>   or delete) into view and knows the *OLD* and *NEW*.
>   (Number of fields can be more than 16)

No.   Create a RULE instead, which can be created on a view:
http://www.us.postgresql.org/users-lounge/docs/7.2/postgres/rules.html

BTW, you can increase the number of parameters accepted by functions by
re-compiling postgres.  Also, 7.3 will have 32 as the default.

-Josh Berkus


pgsql-sql by date:

Previous
From: Акулов Александр
Date:
Subject: Can I create working trigger on view
Next
From: Brian Blaha
Date:
Subject: Apparent referential integrity bug in PL/pgSQL