| From: | ZEUGSWETTER Andreas IZ5 <Andreas(dot)Zeugswetter(at)telecom(dot)at> |
|---|---|
| To: | "'pgsql-hackers(at)postgresql(dot)org'" <pgsql-hackers(at)postgreSQL(dot)org> |
| Subject: | Re: [HACKERS] It is doing my head in |
| Date: | 1999-05-20 13:30:41 |
| Message-ID: | 219F68D65015D011A8E000006F8590C60267B370@sdexcsrv1.f000.d0188.sd.spardat.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Wieck | 1999-05-20 13:40:46 | Re: [HACKERS] It is doing my head in |
| Previous Message | Cary O'Brien | 1999-05-20 13:30:10 | Re: [HACKERS] Off topic - ref spreadsheet |