> Looks like you deleted and recreated the function, without also deleting
> and recreating the trigger that refers to it. Now the trigger is
> referring to a no-longer-existent function OID ... remake the trigger
> and try again.
Excuse other preposterous question of mine, but the reliance of OID
don't go against the Information Principle for relational databases? Even
if PosgreSQL isn't strictly relational, and if triggers and functions aren't
really in the scope of the relational model, what is the rationale for such
exposition of a fairly internal construct as an OID? Perhaps the use of the
name of the function in the internal reference from the trigger would be too
expensive performace-wise, but then perhaps the function could be at least
marked invalid, like the ORA-04063 error in
order to make troubleshooting simpler.
Just my 2c.
/ \ Leandro Guimarães Faria Corcete Dutra +55 (11) 3040 8913
\ / Amdocs Brasil Ltda at Tele Danmark +45 3387 5214
X http://terravista.pt./Enseada/1989/ mailto:leandrod(at)amdocs(dot)com
/ \ Campanha fita ASCII mailto:moreno(at)tdk(dot)dk
pgsql-novice by date
|Next:||From: Peter Eisentraut||Date: 2001-04-19 15:47:58|
|Subject: Re: < Int4 - limit >|
|Previous:||From: Tom Lane||Date: 2001-04-19 04:58:04|
|Subject: Re: Trigger and Function Question |