Re: [HACKERS] It is doing my head in

Поиск
Список
Период
Сортировка
От ZEUGSWETTER Andreas IZ5
Тема Re: [HACKERS] It is doing my head in
Дата
Msg-id 219F68D65015D011A8E000006F8590C60267B370@sdexcsrv1.f000.d0188.sd.spardat.at
обсуждение исходный текст
Ответы Re: [HACKERS] It is doing my head in  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Cary O'Brien"
Дата:
Сообщение: Re: [HACKERS] Off topic - ref spreadsheet
Следующее
От: jwieck@debis.com (Jan Wieck)
Дата:
Сообщение: Re: [HACKERS] It is doing my head in