ECPG Connect user :variable problem

From: Ryan Mooney <ryan(at)pcslink(dot)com>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: ECPG Connect user :variable problem
Date: 2003-08-19 22:17:08
Message-ID: 20030819221656.GA10232@pcslink.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs 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(at)pcslink(dot)com
<-=-=-=-=-=-=-><-=-=-=-=-=-><-=-=-=-=-=-><-=-=-=-=-=-><-=-=-=-=-=-=->

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Ryan Mooney 2003-08-20 00:43:07 Re: [INTERFACES] ECPG Connect user :variable problem
Previous Message Giacomo Cariello 2003-08-19 18:31:30 repalloc bug

Browse pgsql-interfaces by date

  From Date Subject
Next Message Ryan Mooney 2003-08-20 00:43:07 Re: [INTERFACES] ECPG Connect user :variable problem
Previous Message Tom Lane 2003-08-19 02:50:06 Re: Help with retrieving large results sets and memory usage.