Re: explain doesn't work with execute using

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: explain doesn't work with execute using
Дата
Msg-id 22117.1212337120@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: explain doesn't work with execute using  ("Pavel Stehule" <pavel.stehule@gmail.com>)
Ответы Re: explain doesn't work with execute using
Список pgsql-hackers
"Pavel Stehule" <pavel.stehule@gmail.com> writes:
> 2008/6/1 Tom Lane <tgl@sss.pgh.pa.us>:
>> What do you think a "less invasive" patch would be, anyway?  I don't
>> buy that, say, having SPI_cursor_open_with_args set the flag but
>> SPI_cursor_open not do so is any safer.  There is no difference between
>> the two as to what might get executed, so if there's a problem then
>> both would be at risk.

> SPI_cursor_open_with_args is new function, it's used only in FOR
> EXECUTE statement - and in this context variables are really
> constants.

This argument seems entirely bogus.  How are they any more constant
than in the other case?  The value isn't going to change for the life
of the portal in either case.

ISTM you're expecting EXPLAIN to behave in some magic way that has
got little to do with "correctness".
        regards, tom lane


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

Предыдущее
От: Ron Mayer
Дата:
Сообщение: Re: Overhauling GUCS
Следующее
От: "Pavel Stehule"
Дата:
Сообщение: Re: explain doesn't work with execute using