From: | Rich Cullingford <rculling(at)sysd(dot)com> |
---|---|
To: | psql-interfaces(at)postgresql(dot)org |
Subject: | Passing NEW to functions inside a trigger function... |
Date: | 2004-04-19 18:59:08 |
Message-ID: | 4084217C.2040300@sysd.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
All,
I'm unable to find this question addressed in the archive, tho' it seems
rather obvious. One often needs to dispatch on different subsets of the
data in NEW inside a PLPGSQL trigger function. It would be most
convenient to just pass NEW itself (or NEW.*) to the function thus
called, but there doesn't seem to be any way to do that. Any use of NEW
inside a function call imbedded in the trigger function, whether in a
SELECT INTO, EXECUTE or PERFORM, leads to a:
ERROR: NEW used in query that is not in a rule
(or sometimes "relation NEW not found.")
I've seen syntax for passing a row of data in ordinary functions, but
not inside triggers.
Any enlightenment appreciated!
Rich Cullingford
rculling(at)sysd(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Brett Schwarz | 2004-04-19 20:02:32 | Re: [HACKERS] Why is libpgtcl still in CVS? |
Previous Message | Bruce Momjian | 2004-04-19 17:46:38 | Re: [HACKERS] Why is libpgtcl still in CVS? |