pl/perl not rethrowing pl/pgsql exceptions - Mailing list pgsql-general

From Merlin Moncure
Subject pl/perl not rethrowing pl/pgsql exceptions
Date
Msg-id b42b73151001050949k3028d282refe9ac46e68c4359@mail.gmail.com
Whole thread Raw
Responses Re: pl/perl not rethrowing pl/pgsql exceptions  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general
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;

merlin

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Large tables, ORDER BY and sequence/index scans
Next
From: Guillaume Lelarge
Date:
Subject: Re: reason for default PGSTAT_ACTIVITY_SIZE