Re: Trapping PL/Perl spi_query_exec errors

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


"Worky Workerson" <worky.workerson@gmail.com> wrote:
> This is probably a really basic question, but how do I trap when
> spi_query_exec returns an error in PL/Perl?

Tom Lane replied:
> I think you don't, without using plperlu :-(.  Unless perhaps recent
> Perls have added an error trapping construct that's separate from eval?

Tom is right, you need plperlu if you want to do this. Or be more careful
in your function by (for example) querying the pg_class table to see if
the table exists. Another alternative is to have pl/perlu do all the
"heavy lifting", and make some more limited wrapper functions in pl/perl.
And for the sake of the archives, it is "spi_exec_query" not "spi_query_exec".

- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200611230659
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8


-----BEGIN PGP SIGNATURE-----

iD8DBQFFZY2yvJuQZxSWSsgRAid1AKCBbLpjAYK/MMpQPiDBKapoOAIqygCfTrme
pDZrkflT0LLUvdlbWDxCoe0=
=OT2k
-----END PGP SIGNATURE-----