PL/pgSQL Trigger Problems - Mailing list pgsql-general

From Gregory Wood
Subject PL/pgSQL Trigger Problems
Date
Msg-id 004601c06932$9a5b9b70$7889ffcc@comstock.com
Whole thread Raw
List 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


pgsql-general by date:

Previous
From: gerardo tagliani
Date:
Subject: Schema
Next
From: Sandeep Joshi
Date:
Subject: Re: question