Thread: Re: [HACKERS] It is doing my head in
> postgres=> create trigger trg1 after insert on smile for each row > postgres-> execute procedure ttt() ; > ERROR: CreateTrigger: function ttt () does not exist > postgres=> \q > > So my question is - why does the create trigger function fail when the > function does in > fact exist ? > The procedure called from a trigger has to return opaque (the triggering tuple). The elog could probably be modified to: > ERROR: CreateTrigger: function ttt () returning opaque does not exist to help find your error. Andreas
ZEUGSWETTER Andreas IZ5 <Andreas.Zeugswetter@telecom.at> writes: > The procedure called from a trigger has to return opaque (the triggering > tuple). > The elog could probably be modified to: >> ERROR: CreateTrigger: function ttt () returning opaque does not exist > to help find your error. I think two separate messages would be better... will fix it. regards, tom lane