Hello,I'mhaving problems withafunction afterthepostgresserverhas been upgraded to8.3.10(Iused8.3.7).I did sometestingandfoundsome strange situations. ------------------------------------------------------------------------------------------------------------ -- not workwiththedirect callfunction (workedbeforetheupgrade) select f_rodar_reportagem(44359, 193097);
-- notworkwith thecallby thetrigger(atrigger callsafunction anditcallsf_rodar_reportagemusingselect and workedbeforetheupgrade) update repesportesmt set estado = '1' where idrepesportesmt = 44359;
-- WORK using Prepare/Execute prepare rodar(int, int) as select f_rodar_reportagem($1, $2); execute rodar(44359, 193097); -------------------------------------------------------------------------------------------------------------
I donotunderstandwhynotworkingafterupgrade, but workedwithprepare/execute,so Itried touseinside afunctionbut did not work.
-- got error in this line on params prepare rodar(int, int) as select f_rodar_reportagem($1, $2);