ECPG Connect user :variable problem

Поиск
Список
Период
Сортировка
От Ryan Mooney
Тема ECPG Connect user :variable problem
Дата
Msg-id 20030819221656.GA10232@pcslink.com
обсуждение исходный текст
Ответы Re: ECPG Connect user :variable problem  (Ryan Mooney <ryan@pcslink.com>)
Re: ECPG Connect user :variable problem  (Ryan Mooney <ryan@pcslink.com>)
Список pgsql-interfaces
Hello,

I'm having a major problem using ecpg with 7.4beta1.  The problem is that
if I try to pass in the username or password as :variables to the EXEC SQL
CONNECT code they are essentially ignored (replaced by " ?").

I've tried it on both redhat 7.2 IA64 and Redhat 9.0 IA32 (different enough 
that I don't think its the platform).   I also tried it with postgres 7.3.2
which seemed to do the "right thing" and put the variables into the ECPGconnect
call.

Any thoughts?

------------------------------<snip "connect.pgc">---------------------------------
int pg_connect(void)
{
   EXEC SQL BEGIN DECLARE SECTION;   char *target = "dbname";   char *connection_name = "myconnection";   char *uname =
"myuser";  char *password = "mypassword";   EXEC SQL END DECLARE SECTION;
 
   EXEC SQL CONNECT TO :target as :connection_name user :uname using :password;

}

------------------------------<snip "connect.c">---------------------------------

int pg_connect(void)
{
/* exec sql begin declare section */            
#line 5 "connect.pgc"char * target  = "dbname" ;
#line 6 "connect.pgc"char * connection_name  = "myconnection" ;
#line 7 "connect.pgc"char * uname  = "myuser" ;
#line 8 "connect.pgc"char * password  = "mypassword" ;
/* exec sql end declare section */
#line 9 "connect.pgc"

{ ECPGconnect(__LINE__, 0, target , " ?" , " ?" , connection_name, 0); }
#line 11 "connect.pgc"


}


-- 
>-=-=-=-=-=-=-<>-=-=-=-=-=-<>-=-=-=-=-=-<>-=-=-=-=-=-<>-=-=-=-=-=-=-<
Ryan Mooney                           ryan@pcslink.com 
<-=-=-=-=-=-=-><-=-=-=-=-=-><-=-=-=-=-=-><-=-=-=-=-=-><-=-=-=-=-=-=-> 


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Help with retrieving large results sets and memory usage.
Следующее
От: Ryan Mooney
Дата:
Сообщение: Re: ECPG Connect user :variable problem