Re: prepared statements & functions

Поиск
Список
Период
Сортировка
От Jean-Yves F. Barbier
Тема Re: prepared statements & functions
Дата
Msg-id 20111204214133.287551ee@anubis.defcon1
обсуждение исходный текст
Ответ на Re: prepared statements & functions  (Andreas Kretschmer <akretschmer@spamfence.net>)
Ответы Re: prepared statements & functions  (Andreas Kretschmer <akretschmer@spamfence.net>)
Список pgsql-novice
On Sun, 4 Dec 2011 09:38:40 +0100
Andreas Kretschmer <akretschmer@spamfence.net> wrote:

> > AFAI understand prepared statements they can accelerate
> > repetitive queries very much - but is it possible to
> > prepare them from within a function (let say when the user
> > connects), and if so, will they be erased as soon as the
> > user disconnects?
>
> We haven't TRIGGERs for events like 'USER LOGGED IN' or so ...

That was not my thinking; it was more like:
user connects
user calls the function
function creates prepared statements
user call other fun that uses these prepared statements

JY
--
War is menstruation envy.

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

Предыдущее
От: "Ioannis Anagnostopoulos"
Дата:
Сообщение: Re: Linux server connection process consumes all memory
Следующее
От: Lisibeth Troconis
Дата:
Сообщение: problema con comando \c en el psql