Re: Can I create working trigger on view

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: ?????? ?(dot)?(dot) <akulov(at)ien(dot)ru>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Can I create working trigger on view
Date: 2002-10-18 05:27:14
Message-ID: web-1790713@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Brian Blaha 2002-10-18 07:15:32 Apparent referential integrity bug in PL/pgSQL
Previous Message Акулов Александр 2002-10-18 05:06:03 Can I create working trigger on view