Re: Avoiding bad prepared-statement plans.

Поиск
Список
Период
Сортировка
От Pierre C
Тема Re: Avoiding bad prepared-statement plans.
Дата
Msg-id op.u8b0wnhteorkce@localhost
обсуждение исходный текст
Ответ на Re: Avoiding bad prepared-statement plans.  (Dimitri Fontaine <dfontaine@hi-media.com>)
Ответы Re: Avoiding bad prepared-statement plans.
Список pgsql-hackers
On Thu, 18 Feb 2010 16:09:42 +0100, Dimitri Fontaine  
<dfontaine@hi-media.com> wrote:

> "Pierre C" <lists@peufeu.com> writes:
>> Problem with prepared statements is they're a chore to use in web apps,
>> especially PHP, since after grabbing a connection from the pool, you  
>> don't
>> know if it has prepared plans in it or not.
>
> Have you met preprepare yet?
>
>   http://preprepare.projects.postgresql.org/README.html
>   http://packages.debian.org/source/sid/preprepare
>
> Regards,

Hey, this thing is nice.
How hard would it be to put a hook in pg so that, instead of raising an  
error and cancelling the txn when EXECUTing a statement that is not  
prepared, it would call a user function (of the user's choice) which  
would, if possible, prepare said statement, or if not, raise the error ?


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

Предыдущее
От: Dimitri Fontaine
Дата:
Сообщение: Re: remove contrib/xml2
Следующее
От: Dimitri Fontaine
Дата:
Сообщение: Re: Avoiding bad prepared-statement plans.