Skip site navigation (1) Skip section navigation (2)

Re: [repost] trigger update time

From: Rory Campbell-Lange <rory(at)campbell-lange(dot)net>
To: Manfred Koizar <mkoi-pg(at)aon(dot)at>
Cc: Postgresql Novice List <pgsql-novice(at)postgresql(dot)org>
Subject: Re: [repost] trigger update time
Date: 2002-06-19 14:00:59
Message-ID: 20020619140059.GA8438@campbell-lange.net (view raw or flat)
Thread:
Lists: pgsql-novice
On 19/06/02, Manfred Koizar (mkoi-pg(at)aon(dot)at) wrote:
> On Wed, 19 Jun 2002 09:36:34 +0100, Rory Campbell-Lange
> <rory(at)campbell-lange(dot)net> wrote:
> >I am trying to update a timestamp value in a related table using
> >functions and triggers, but failing miserably!
> 
> timestamp is not the problem.
> 
> >CREATE FUNCTION "fnTU" () RETURNS opaque AS 'BEGIN
> >UPDATE a SET tstamp = new.tstamp;
> >WHERE new.a_id = id;
> >RETURN new;
> >END' LANGUAGE 'plpgsql';
>     ^
>     Insert ; here!

Apologies and Thanks!, Manfred.

However I now get the following error:
obf=# insert into messages (id_person, id_idea, content) values
obf-# (5, 7, 'but all this txting is irritating!');
ERROR:  fmgr_info: function 51144: cache lookup failed

Is this an indexing problem?

-- 
Rory Campbell-Lange 
<rory(at)campbell-lange(dot)net>
<www.campbell-lange.net>

In response to

Responses

pgsql-novice by date

Next:From: Jillian CarrollDate: 2002-06-19 14:06:46
Subject: ODBC Error
Previous:From: Tom LaneDate: 2002-06-19 13:10:32
Subject: Re: [repost] trigger update time

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group