| 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: | Whole Thread | Raw Message | 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 |