Re: Prepared statements question

Поиск
Список
Период
Сортировка
От Kevin Brown
Тема Re: Prepared statements question
Дата
Msg-id 20030113031241.GF20180@filer
обсуждение исходный текст
Ответ на Re: Prepared statements question  (Neil Conway <neilc@samurai.com>)
Ответы Re: Prepared statements question  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Список pgsql-hackers
Neil Conway wrote:
> On Thu, 2003-01-09 at 22:48, Christopher Kings-Lynne wrote:
> > With prepared statements being all well and good, how do I know if the query
> > has not yet been prepared in the backend?  Or is this simply a situation
> > where I can't win?
> 
> Try the EXECUTE; if it fails, run the PREPARE and then rerun the
> EXECUTE.

Erm...won't the failed EXECUTE boot you out of the middle of a
transaction?  The documentation doesn't make it clear what happens in
that case, and I don't have 7.3.x running to check for myself...



-- 
Kevin Brown                          kevin@sysexperts.com


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: MOVE LAST: why?
Следующее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: Re: Prepared statements question