Hello. In PL/PGSQL I could write:
BEGIN SELECT * FROM non_existed_table; EXCEPTION WHEN ... THEN ... END; How to do it in PL/Perl? I tried the standard for Perl trapping method: eval { spi_exec_query("SELECT * FROM non_existed_table"); }; if ($@) { ... } but it does not work - it says that "eval is not safe" or something like that. But I use eval with {}, not with quotes, so - it has to be safe. So, how to trap errors in this case?