PL/pgSQL Trigger Problems

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

Responses

Browse pgsql-general by date

  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