Re: [GENERAL] SPI_ERROR_CONNECT in plperl function

2009-01-08 Thread Christian Schröder
Tom Lane wrote: Hmph ... looks like plperl is shy a few SPI_push/SPI_pop calls. I've applied a patch for this --- it'll be in the next set of update releases. Great. Thanks a lot! The whole PostgreSQL stuff is really amazing! :-) Regards, Christian -- Deriva GmbH

Re: [GENERAL] SPI_ERROR_CONNECT in plperl function

2009-01-07 Thread Tom Lane
I wrote: > =?ISO-8859-1?Q?Christian_Schr=F6der?= writes: >> When I try to call the function I get the following error message: >> test=# select * from testfunc(); >> ERROR: error from Perl function: SPI_connect failed: SPI_ERROR_CONNECT >> at line 2. > Hmph ... looks like plperl is shy a few S

Re: [GENERAL] SPI_ERROR_CONNECT in plperl function

2009-01-04 Thread Tom Lane
=?ISO-8859-1?Q?Christian_Schr=F6der?= writes: > When I try to call the function I get the following error message: > test=# select * from testfunc(); > ERROR: error from Perl function: SPI_connect failed: SPI_ERROR_CONNECT > at line 2. Hmph ... looks like plperl is shy a few SPI_push/SPI_pop c

[GENERAL] SPI_ERROR_CONNECT in plperl function

2009-01-04 Thread Christian Schröder
Hi list, I have found the following problem: I have declared a domain datatype with a check constraint. The check constraint uses a plpgsql function: CREATE FUNCTION domain_ok(value integer) RETURNS boolean AS $$ BEGIN RETURN value > 0; END; $$ LANGUAGE plpgsql; CREATE DOMAIN testdomain int