Postgres Pro
Downloads
Home   >   mailing lists

using NEW in a trigger calling a function in plpgsql... - Mailing list pgsql-general

From Creager, Robert S
Subject using NEW in a trigger calling a function in plpgsql...
Date
Msg-id 10FE17AD5F7ED31188CE002048406DE8514D1D@lsv-msg06.stortek.com
Whole thread Raw
Responses Re: using NEW in a trigger calling a function in plpgsql...  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: 100.179370@germanynet.de (Martin Jacobs)
Date:
Subject: Re:
Next
From: Limin Liu
Date:
Subject: Can I use SPI in postgres.c