Re: NOT EXIST for PREPARE

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: NOT EXIST for PREPARE
Дата
Msg-id 20160322140526.GK3790@awork2.anarazel.de
обсуждение исходный текст
Ответ на Re: NOT EXIST for PREPARE  (Yury Zhuravlev <u.zhuravlev@postgrespro.ru>)
Список pgsql-hackers
On 2016-03-22 16:51:26 +0300, Yury Zhuravlev wrote:
> Andres Freund wrote:
> >you'd still need to compare the
> >statement somehow
> 
> You right, I think about that as syntax sugar. Maybe with some performance
> increase but hardly. We can save on a round trip.

If anything what'd be useful would be DEALLOCATE IF EXISTS; that'd allow
you to use prepare safely this way.

> It may be necessary to add an index on the field "statement"?

It's not an actual table, it's a view over a function.



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

Предыдущее
От: Yury Zhuravlev
Дата:
Сообщение: Re: NOT EXIST for PREPARE
Следующее
От: Fujii Masao
Дата:
Сообщение: Re: Support for N synchronous standby servers - take 2