Re: [GENERAL] pl/perl not rethrowing pl/pgsql exceptions

2010-01-05 Thread Merlin Moncure
On Tue, Jan 5, 2010 at 12:49 PM, Merlin Moncure 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("sele

[GENERAL] pl/perl not rethrowing pl/pgsql exceptions

2010-01-05 Thread Merlin Moncure
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