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
|
Список | 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 по дате отправления: