Обсуждение: 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