Re: [GENERAL] Triggers and sql functions not working... - Mailing list pgsql-general

>>>>> "GY" == Greg Youngblood <YoungblG@houstoncellular.com> writes:

. . .

 GY> create function update_tab2 () returns int4 as 'insert into tab2 (l,a,g)
 GY> select distinct a.l,b.a,b.c from tab2 a,tab1 b where b.a not in (select
 GY> distinct a from tab2); select 1 as exitvalue;' language 'sql';

. . .

 GY> create trigger new_tab1_a after insert on tab1 for each row execute
 GY> procedure update_tab2 ();

 GY> generates:

 GY> ERROR:  CreateTrigger: function update_tab2 () does not exist.

Function for triggers must have signature 'xxx() returns opaque', but
not '... returns int'. Pehaps this is your mistake?

--
Anatoly K. Lasareff              Email:       tolik@icomm.ru
Senior programmer