Re: Triggers for inserting on VIEWS - Mailing list pgsql-sql

From Tom Lane
Subject Re: Triggers for inserting on VIEWS
Date
Msg-id 4170.1028399684@sss.pgh.pa.us
Whole thread Raw
In response to Triggers for inserting on VIEWS  (Marc SCHAEFER <schaefer@alphanet.ch>)
List pgsql-sql
Marc SCHAEFER <schaefer@alphanet.ch> writes:
> at least with PostgreSQL 7.1 it was possible to create a trigger on a
> view.

Use a rule instead.  7.2 will reject an attempt to insert into a view
without a replacement rule, so a trigger would do you no good anyhow.
(I thought that behavior went back further than 7.2, actually.)
        regards, tom lane


pgsql-sql by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: Triggers for inserting on VIEWS
Next
From: "Josh Berkus"
Date:
Subject: STATISTICS?