| From: | Marek Lewczuk <marek(at)lewczuk(dot)com> |
|---|---|
| To: | PGSQL <pgsql-general(at)postgresql(dot)org> |
| Subject: | SPI_ERROR_CONNECT within pl/pgsql, PG 8.4 |
| Date: | 2009-07-10 10:58:41 |
| Message-ID: | daadfdc20907100358j7c0f3072s68caa751a81b1a54@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 =
$2 where id = $3 [ $4 ][1]::Integer"
PL/pgSQL function "price_rebuildpricelistvalidity" line 54 at
SQL statement
SQL statement "SELECT price_rebuildPriceListValidity( $1 )"
PL/pgSQL function "price_aftertrigger" line 54 at PERFORM
LOCATION: plpgsql_call_handler, pl_handler.c:77
As I said it was thrown within PG8.4, but when it was executed within
PG8.3.5 there were no problems at all. Second execution of same
statement didn't throw an error too. Can anyone explain what it means.
Best regards,
ML
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vanessa Lopez | 2009-07-10 11:47:42 | Re: REINDEX "is not a btree" |
| Previous Message | Tim Uckun | 2009-07-10 10:45:45 | Re: ubuntu packages for 8.4 |