| 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:47:19 |
| Message-ID: | 1172364439l.30468l.6l@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)).
Maybe you don't understand, I want to modify the
underlying tables by using the view, because the
view presents something that is more understandable
to the user.
Sorry to be testy. It's been a long day
going down a road and finding a roadblock at the end and
the postgresql docs have never let me down before.
Karl <kop(at)meme(dot)com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2007-02-25 00:47:56 | Re: Why can't I put a BEFORE EACH ROW trigger on a view? |
| Previous Message | Karl O. Pinc | 2007-02-25 00:39:23 | Re: Why can't I put a BEFORE EACH ROW trigger on a view? |