Re: a trigger question

El Jun 6, Gregory Wood escribio: 

> Sounds like you did a CREATE FUNCTION, then a CREATE TRIGGER, then needed to
> DROP and reCREATE your function. The trigger is still looking for the old
> function, try DROP TRIGGER and CREATE TRIGGER again to make sure it points
> to the current version.

Also remember that you can just CREATE OR REPLACE the function so that
you don't have to drop and recreate the trigger afterwards.

-- 
Alvaro Herrera ()
"Pido que me den el Nobel por razones humanitarias" (Nicanor Parra)