X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id C2395D1BA81
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Tue, 19 Aug 2003 19:17:17 -0300 (ADT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 93453-09
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Tue, 19 Aug 2003 19:17:09 -0300 (ADT)
Received: from pcslink.com (pcslink.com [208.145.64.10])
	by svr1.postgresql.org (Postfix) with ESMTP id ED256D1BA93
	for <pgsql-interfaces@postgresql.org>;
	Tue, 19 Aug 2003 19:17:05 -0300 (ADT)
Received: (from ryan@localhost) by pcslink.com (8.9.3/8.9.2) id PAA26671
	for pgsql-interfaces@postgresql.org;
	Tue, 19 Aug 2003 15:17:08 -0700 (MST) (envelope-from ryan)
Date: Tue, 19 Aug 2003 12:17:08 -1000
From: Ryan Mooney <ryan@pcslink.com>
To: pgsql-interfaces@postgresql.org
Subject: ECPG Connect user :variable problem
Message-ID: <20030819221656.GA10232@pcslink.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.3.25i
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200308/54
X-Sequence-Number: 4408


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 
<-=-=-=-=-=-=-><-=-=-=-=-=-><-=-=-=-=-=-><-=-=-=-=-=-><-=-=-=-=-=-=->