| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Jeff Davis <pgsql(at)j-davis(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Michael Nolan <htfoot(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Returning NEW in an on-delete trigger |
| Date: | 2008-09-24 19:51:29 |
| Message-ID: | 200809241951.m8OJpTb29024@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Jeff Davis wrote:
> On Thu, 2008-09-18 at 15:04 -0400, Tom Lane wrote:
> > This does seem like a bit of a gotcha for someone who writes RETURN NEW
> > instead of RETURN OLD or vice versa, but I'm not sure how much we can do
> > about that. Lots of people like to write triggers that fire on multiple
> > event types, so we couldn't throw a syntax error for such a reference.
> > A runtime error for a use of the variable might be possible, but a quick
> > look at the code doesn't make it look easy.
> >
>
> Here's a doc patch that may clear up some of the confusion.
Thanks, patch applied.
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-09-24 20:03:02 | Re: case expression |
| Previous Message | Casey Allen Shobe | 2008-09-24 19:44:33 | Re: Oracle and Postgresql |