Re: TRIGGER with WHEN clause

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Cc: KaiGai Kohei <kaigai@ak.jp.nec.com>, KaiGai Kohei <kaigai@kaigai.gr.jp>, pgsql-hackers@postgresql.org
Date: 2009-11-20T20:41:45Z
Lists: pgsql-hackers
Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp> writes:
> [ TRIGGER WHEN patch ]

Applied with assorted revisions.  AFAICT the system column issue is only
a problem for NEW references in BEFORE triggers --- those columns do
read correctly in OLD, and all the time in AFTER triggers.  I revised
the parsing logic to enforce that.  The patch also missed establishing
dependencies for stuff referenced in the WHEN expression, and there were
a few other minor problems.

			regards, tom lane