Re: How to use SPI_saveplan

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: How to use SPI_saveplan
Дата
Msg-id 29751.1157851839@sss.pgh.pa.us
обсуждение исходный текст
Ответ на How to use SPI_saveplan  (Jack Orenstein <jao@geophile.com>)
Ответы Re: How to use SPI_saveplan  (Jack Orenstein <jao@geophile.com>)
Список pgsql-general
Jack Orenstein <jao@geophile.com> writes:
> I'm missing something very basic. If I do this:

>      Datum foobar(PG_FUNCTION_ARGS)
>      {
>          ...
>          void* plan = SPI_prepare(...);
>          void* saved_plan = SPI_saveplan(plan);
>          ...
>      }

> then how can I access the saved plan in a later invocation of foobar?

It's up to you to save the pointer somewhere where you can find it again
when you need it.  If there's only one interesting plan, use a static
variable.  Otherwise, you'll need some sort of data structure to map
from what-you-need to the-plan-that-does-it.  You can find examples of
these approaches in the PG sources (from memory, ruleutils.c has some
examples of the former approach while ri_triggers.c does the latter).

            regards, tom lane

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

Предыдущее
От: "Jaime Casanova"
Дата:
Сообщение: Data Warehouse
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Is this logical?