I use the following code to create a function:
create function employee_stats_update() returns int4
as 'insert into employee_stats values (
new.employee_name);
select 1 as ignore_this'
language 'plpgsql';
Then I create the following trigger:
create trigger update_employee_stats
before insert on employee_master for each row
execute procedure employee_stats_update();
This is what I get back when I try to create the trigger:
ERROR: CreateTrigger: function employee_stats_update () does not exist
Adam