Re: pl/perl not rethrowing pl/pgsql exceptions

On Tue, Jan 5, 2010 at 12:49 PM, Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:
> is this behavior correct?
>
> create or replace function error() returns text as
> $$
> begin
>  raise exception 'test!';
> end;
> $$ language plpgsql;
>
>
> create or replace function test() returns text as
> $$
>  my $res = spi_query("select error()"); # this error is ignored
>  my $res = spi_query("something stupid!"); # this is not?
> $$ language plperlu;

I got the answer on IRC. spi_query only parses the statement but does
not necessarily execute it (it's more like spi_prepare).
spi_exec_query works the way I think it should.

merlin