

> 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

Thu, 20 May 1999 15:30:41 +0200
ZEUGSWETTER Andreas IZ5 <Andreas.Zeugswetter@telecom.at>
Re: [HACKERS] It is doing my head in
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

Thu, 20 May 1999 09:57:49 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] It is doing my head in 