[GENERAL] SPI_ERROR_CONNECT within pl/pgsql PG 8.4

2009-08-19 Thread Omar Bettin
Hello, Somebody has solved the problem that was not present in 8.3.x ? Thankyou Omar

Re: [GENERAL] SPI_ERROR_CONNECT within pl/pgsql, PG 8.4

2009-07-14 Thread Marek Lewczuk
2009/7/13 Tom Lane : > No, you're misinterpreting the message.  What that code likely means > is that something is trying to use SPI and finding plpgsql already > connected.  In other words, plpgsql forgets to do a SPI_push() before > calling something that might try to use SPI re-entrantly.  It sh

Re: [GENERAL] SPI_ERROR_CONNECT within pl/pgsql, PG 8.4

2009-07-13 Thread Marek Lewczuk
2009/7/13 Tom Lane : > No, you're misinterpreting the message.  What that code likely means > is that something is trying to use SPI and finding plpgsql already > connected.  In other words, plpgsql forgets to do a SPI_push() before > calling something that might try to use SPI re-entrantly.  It sh

Re: [GENERAL] SPI_ERROR_CONNECT within pl/pgsql, PG 8.4

2009-07-13 Thread Tom Lane
Marek Lewczuk writes: >>> I have made an upgrade to PG 8.4 and following error was thrown during >>> execution of some pl/pgsql function: >>> ERROR:  XX000: SPI_connect failed: SPI_ERROR_CONNECT >> > I can't prepare an example, cause I can't reproduce this error in an > example, but in production

Re: [GENERAL] SPI_ERROR_CONNECT within pl/pgsql, PG 8.4

2009-07-13 Thread Marek Lewczuk
2009/7/10 Tom Lane : > Marek Lewczuk writes: >> I have made an upgrade to PG 8.4 and following error was thrown during >> execution of some pl/pgsql function: >> ERROR:  XX000: SPI_connect failed: SPI_ERROR_CONNECT > > Really?  Could we see a self-contained example? Really... And what is very prob

Re: [GENERAL] SPI_ERROR_CONNECT within pl/pgsql, PG 8.4

2009-07-10 Thread Tom Lane
Marek Lewczuk writes: > I have made an upgrade to PG 8.4 and following error was thrown during > execution of some pl/pgsql function: > ERROR: XX000: SPI_connect failed: SPI_ERROR_CONNECT Really? Could we see a self-contained example? regards, tom lane -- Sent via pgs

[GENERAL] SPI_ERROR_CONNECT within pl/pgsql, PG 8.4

2009-07-10 Thread Marek Lewczuk
Hello, I have made an upgrade to PG 8.4 and following error was thrown during execution of some pl/pgsql function: ERROR: XX000: SPI_connect failed: SPI_ERROR_CONNECT CONTEXT: PL/pgSQL function "price_aftertrigger" line 30 at IF SQL statement "update price set validFrom = $1 , validTo =