Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group