From: | "Adam H(dot) Pendleton" <apendleton(at)vgsinc(dot)com> |
---|---|
To: | <pgsql-sql(at)hub(dot)org> |
Subject: | Function error |
Date: | 1999-05-12 13:40:24 |
Message-ID: | 005501be9c7c$fde98550$bdd0be80@belvoir.army.mil |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
I created the following function:
create function employee_pay_update() returns opaque as '
begin
insert into employee_payroll values (
new.employee_id,
new.employee_name
);
' language 'plpgsql';
This is just supposed to insert any record inserted into a table into
employee_payroll. I don't need any sort of error checking as that will be
done elsewhere. When I try to insert into the first table, and the trigger
calls this function I get this error:
java.sql.SQLException: ERROR: fmgr_info: function 19265: cache lookup
failed
Did I forget to do something?
Adam
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Si hoc legere scis nimium eruditionis habes.
From | Date | Subject | |
---|---|---|---|
Next Message | Marcio Macedo | 1999-05-12 13:54:03 | question about money type |
Previous Message | Jan Wieck | 1999-05-11 17:45:14 | Re: [SQL] plpgsql error |