Re: EXPLAIN, utility statement parameters, and recent plpgsql changes

Поиск
Список
Период
Сортировка
От Dimitri Fontaine
Тема Re: EXPLAIN, utility statement parameters, and recent plpgsql changes
Дата
Msg-id m28wc01o90.fsf@hi-media.com
обсуждение исходный текст
Ответ на EXPLAIN, utility statement parameters, and recent plpgsql changes  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: EXPLAIN, utility statement parameters, and recent plpgsql changes
Список pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> writes:
> This works well enough for regular DML statements, but it falls down for
> EXPLAIN which is a utility statement, because *parse analysis of utility
> statements doesn't do anything*.  EXPLAIN actually does the parse
> analysis of its contained statement at the beginning of execution.
> And that is too late, in the scenario Pavel exhibited.  Why is it too
> late?  Because SPI_cursor_open_internal() intentionally "freezes" the
> ParamListInfo struct after doing initial parsing: what it copies into
> the cursor portal is just a static list of data values without the
> parser hooks (see copyParamList).

Would it make any sense for this function to get to call the hook in the
case a utility statement is being processed?

Regards,
-- 
dim


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

Предыдущее
От: David Fetter
Дата:
Сообщение: Re: Miscellaneous changes to plperl [PATCH]
Следующее
От: Dimitri Fontaine
Дата:
Сообщение: Re: Streaming replication, retrying from archive