using NEW in a trigger calling a function in plpgsql...
Creager, Robert S <creagrs@louisville.stortek.com>
From: "Creager, Robert S" <CreagRS@LOUISVILLE.STORTEK.COM>
To: "'General - PGSQL'" <pgsql-general@postgresql.org>
Date: 2001-03-22T01:24:15Z
Lists: pgsql-general
Hey, I'm attempting to create update/insert/delete triggers which end up relying on two functions, add_influence and remove_influence (both plpgsql functions). I've attempted to call these functions which accepts a known table as a parameter, and am PERFORM'ing a call to that function with NEW as the parameter. The error I receive is: ERROR: NEW used in non-rule query. Can I accomplish this in plpgsql, or do I need to switch over to C/C++? I would prefer to not re-select the data info another variable... Thanks, Rob Robert Creager Senior Software Engineer Client Server Library 303.673.2365 V 303.661.5379 F 888.912.4458 P StorageTek INFORMATION made POWERFUL