Re: Why can't I put a BEFORE EACH ROW trigger on a view?

From: "Karl O(dot) Pinc" <kop(at)meme(dot)com>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Why can't I put a BEFORE EACH ROW trigger on a view?
Date: 2007-02-25 00:39:23
Message-ID: 1172363963l.30468l.5l@mofo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On 02/24/2007 06:25:54 PM, Joshua D. Drake wrote:

> create your table, create your triggers on the table.
> Use a view on top of the table for viewing (there is no such thing as
> a
> select rule (well there is, but it is called a view)).

Yes, and you can't put a BEFORE EACH ROW trigger
on a view, which is my problem. I have _additional_
constraints to place on modifications done through
views, and trickyness involved in modifying the
underlying tables.

Karl <kop(at)meme(dot)com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Karl O. Pinc 2007-02-25 00:47:19 Re: Why can't I put a BEFORE EACH ROW trigger on a view?
Previous Message Joshua D. Drake 2007-02-25 00:25:54 Re: Why can't I put a BEFORE EACH ROW trigger on a view?