On Tue, Jan 5, 2010 at 12:49 PM, Merlin Moncure <mmoncure@gmail.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