Re: deallocating prepared statements

Поиск
Список
Период
Сортировка
От Haszlakiewicz, Eric
Тема Re: deallocating prepared statements
Дата
Msg-id 9D29FD18CBD74A478CBA86E6EF6DBAD40308029E@CHI4EVS04.corp.transunion.com
обсуждение исходный текст
Ответ на Re: deallocating prepared statements  (Michael Meskes <meskes@postgresql.org>)
Ответы Re: deallocating prepared statements  (Michael Meskes <meskes@postgresql.org>)
Список pgsql-interfaces
>From: Michael Meskes [mailto:meskes@postgresql.org]
>On Tue, Dec 02, 2008 at 01:22:46PM -0600, Haszlakiewicz, Eric wrote:
>> figure out how to deallocate prepared statements.  I tried
>using esql to
>> do it (since the docs say that "it is only for use in embedded sql"):
>>
>> exec sql begin declare section;
>>     const char *stmtName = "exec_stmt";
>> exec sql end declare section;
>> exec sql deallocate :stmtName;
>
>This will not work unless you do more in ECPG. Without
>preparing a statement,
>having a connection etc. there is no way to deallocate the statement.
>
>If you mix libpq and ecpg you should know what you do.

So why is preparing a statement in ecpg different from preparing one
with libpq?  Isn't the actual prepare done on the server?

eric



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

Предыдущее
От: Michael Meskes
Дата:
Сообщение: Re: deallocating prepared statements
Следующее
От: "Haszlakiewicz, Eric"
Дата:
Сообщение: Re: deallocating prepared statements