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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-06-19 14:52:28 | Re: ODBC Error |
Previous Message | Jillian Carroll | 2002-06-19 14:06:46 | ODBC Error |