Re: PQexecParams and CURSOR

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: PQexecParams and CURSOR
Дата
Msg-id 2082.1105977596@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: PQexecParams and CURSOR  ("Laurent Marzullo" <laurent.marzullo@atosorigin.com>)
Список pgsql-general
"Laurent Marzullo" <laurent.marzullo@atosorigin.com> writes:
> Ok so here is the full TEST program I try to run:

I think you are running into an issue that was fixed during the 8.0
development cycle.  From the CVS logs:

2004-08-01 21:30  tgl

    Allow DECLARE CURSOR to take parameters from the portal in which it
    is executed.  Previously, the DECLARE would succeed but subsequent
    FETCHes would fail since the parameter values supplied to DECLARE
    were not propagated to the portal created for the cursor.  In
    support of this, add type Oids to ParamListInfo entries, which
    seems like a good idea anyway since code that extracts a value can
    double-check that it got the type of value it was expecting.
    Oliver Jowett, with minor editorialization by Tom Lane.

So what you are trying to do will work in 8.0 but not in 7.4.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Bo Lorentsen
Дата:
Сообщение: Re: Index optimization ?
Следующее
От: John Cunningham
Дата:
Сообщение: Re: pgpool