Re: [HACKERS] It is doing my head in - Mailing list pgsql-hackers

From ZEUGSWETTER Andreas IZ5
Subject Re: [HACKERS] It is doing my head in
Date
Msg-id 219F68D65015D011A8E000006F8590C60267B370@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
Responses Re: [HACKERS] It is doing my head in
List pgsql-hackers

> 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


pgsql-hackers by date:

Previous
From: "Cary O'Brien"
Date:
Subject: Re: [HACKERS] Off topic - ref spreadsheet
Next
From: jwieck@debis.com (Jan Wieck)
Date:
Subject: Re: [HACKERS] It is doing my head in