"Graham Vickrage" <graham@digitalplanit.com> writes:
> ERROR: CreateTrigger: function get_prod_cost_price() does not exist
> It is clear that it does exist so why does the trigger creation code not
> find it?
Because the code is looking for a function of no arguments, which yours
is not.
The method for dealing with arguments passed to triggers is, um, arcane
--- I think you look in an implicitly declared array named TGARG, or
something like that. You don't receive them as normal function
arguments, anyway.
regards, tom lane