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

Re: [repost] trigger update time

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rory Campbell-Lange <rory(at)campbell-lange(dot)net>
Cc: Manfred Koizar <mkoi-pg(at)aon(dot)at>,Postgresql Novice List <pgsql-novice(at)postgresql(dot)org>
Subject: Re: [repost] trigger update time
Date: 2002-06-19 14:32:11
Message-ID: 4315.1024497131@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
Rory Campbell-Lange <rory(at)campbell-lange(dot)net> writes:
> 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

If you drop and re-create a function then the new function is a new
object with a new OID, so triggers and other references to it will be
broken.  You need to drop and re-create the trigger too.

If you are using 7.2 or later then a better way is to redefine the
function with CREATE OR REPLACE FUNCTION.  This preserves the OID
and thus avoids breaking dependencies.

			regards, tom lane

In response to

pgsql-novice by date

Next:From: Tom LaneDate: 2002-06-19 14:52:28
Subject: Re: ODBC Error
Previous:From: Jillian CarrollDate: 2002-06-19 14:06:46
Subject: ODBC Error

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