"Darrell Skogman" <darrellskogman(at)email(dot)com> writes:
> I want to be able to capture changes to a db with the use of
> triggers. I have created a simple db to test the methods to do
> this. When I change the age in this example, I get the error - "cashe
> lookup failed".
Do you get cache-lookup-failed when you use a non-trigger plpgsql
function, too? I'll bet your plpgsql language definition is broken.
Try dropping and recreating it (see droplang and createlang scripts).
regards, tom lane