Re: Triggers for inserting on VIEWS

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Marc SCHAEFER <schaefer(at)alphanet(dot)ch>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Triggers for inserting on VIEWS
Date: 2002-08-03 18:34:44
Message-ID: 4170.1028399684@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Marc SCHAEFER <schaefer(at)alphanet(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2002-08-03 19:26:23 STATISTICS?
Previous Message Josh Berkus 2002-08-03 18:33:50 Re: Triggers for inserting on VIEWS