From: | "Gregory Wood" <gregw(at)com-stock(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | PL/pgSQL Trigger Problems |
Date: | 2000-12-18 20:39:22 |
Message-ID: | 004601c06932$9a5b9b70$7889ffcc@comstock.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm having problems getting a simple PL/pgSQL trigger to work. I suspect
that something may not be set up correctly, but I have no idea what.
Specifically, I'm trying to get the example working in the 'PL/pgSQL Trigger
Procedure' section of the documentation (located at:
http://www.postgresql.org/docs/postgres/x4418.htm )
Earlier, it was telling me that there was a Parse Error when I tried to
insert a value. Currently the error message I get is: "fmgr_info: function
4605120: cache lookup failed"
And for what it's worth, I did install plpgsql for my database as detailed
in the example in the documentation (located at:
http://www.postgresql.org/docs/postgres/xplang.htm#AEN22060 ). Specifically
I executed both the CREATE FUNCTION and CREATE TRUSTED PROCEDURAL LANGUAGE
statements.
Any help would be most appreciated.
Gregory Wood
From | Date | Subject | |
---|---|---|---|
Next Message | Tulio Oliveira | 2000-12-18 20:55:06 | Re: Foreign Keys and OIDs |
Previous Message | gerardo tagliani | 2000-12-18 18:15:29 | Schema |