statement EXECUTE isn't possible call from SPI_execute_with_args function

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: statement EXECUTE isn't possible call from SPI_execute_with_args function
Date: 2011-01-18 22:49:29
Message-ID: AANLkTi=YK0qeoofkvkdt5=mwB8hMX0bRdnHynQqwDt8K@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello

I can't to execure a prepared statement with one parameter via
SPI_execute_with_args function.

pavel=# select name, statement from pg_prepared_statements ;
name │ statement
──────┼────────────────────────────────
xx │ PREPARE "xx" AS select 10 + $1
(1 row)

EXECUTE "xx"($1)

ERROR: there is no parameter $1 - but function is called with one parameter

Regards

Pavel Stehule

Browse pgsql-bugs by date

  From Date Subject
Next Message Benoygopal 2011-01-19 04:20:42 Re: BUG #5791: Tables are not viewing through pgadmin
Previous Message Daniel Popowich 2011-01-18 16:30:04 BUG #5842: Memory leak in PL/Python when taking slices of results