Re: [PERFORM] Bulk persistence strategy

Поиск
Список
Период
Сортировка
От Riaan Stander
Тема Re: [PERFORM] Bulk persistence strategy
Дата
Msg-id 7258b091-8126-6c15-9b26-2f2938158514@exa.co.za
обсуждение исходный текст
Ответ на Re: [PERFORM] Bulk persistence strategy  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-performance
> On 22 May 2017 at 09:06, Riaan Stander <rstander@exa.co.za> wrote:
>
>>> It sounds like you don't know about anonymous code blocks with DO
>>> https://www.postgresql.org/docs/devel/static/sql-do.html
>>>
>> Yes I do know about that feature. My first implemented generated an
>> anonymous code block, but to my utter dismay once I tried actually doing
>> parameter binding from the application it did not work. This seems to be a
>> Postgres limitation actually stated in the documentation. The anonymous code
>> block is treated as a function body with no parameters.
>>
>> Thanks for the suggestion though.
> Perhaps we should look into parameterisable DO statements.
>
Now that I would second!!




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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: [PERFORM] Bulk persistence strategy
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [PERFORM] Bulk persistence strategy