From: Philip Yarra <philip@utiba.com>
Organization: Utiba
To: Michael Meskes <meskes@postgresql.org>
Subject: Re: ECPG CVS version problems
Date: Tue, 22 Apr 2003 13:45:40 +1000
User-Agent: KMail/1.4.1
Cc: pgsql-interfaces@postgresql.org
References: <200303280200.h2S20N218363@candle.pha.pa.us>
	<200303311023.04279.philip@utiba.com>
	<20030410172004.GB6995@feivel.fam-meskes.de>
In-Reply-To: <20030410172004.GB6995@feivel.fam-meskes.de>
MIME-Version: 1.0
Content-Type: Multipart/Mixed;
	boundary="------------Boundary-00=_4S7Q5YSFK1A28XT22I6D"
Message-Id: <200304221345.40455.philip@utiba.com>

--------------Boundary-00=_4S7Q5YSFK1A28XT22I6D
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

On Fri, 11 Apr 2003 03:20, Michael Meskes wrote:
> Can you take ecpg from CVS? I will not be able to answer email for about
> a two week long vacation trip, but everything I've done so far is in
> CVS.

Hi Michael, I grabbed everything from CVS and tried building, but ran into =
a=20
few problems.

Bison 1.35 and 1.50 both have bugs that prevent successful compilation, so =
I=20
moved to 1.85. This appears to work okay. Is there some way during configur=
e=20
to check for broken bison versions and complain loudly?

Once I compiled the source tree, and got it installed, I ran into further=
=20
problems as soon as I tried to link against the ecpg libs:

$ gcc -I/usr/local/pgsql/include -L/usr/local/pgsql/lib -lecpg test.c
/usr/local/pgsql/lib/libecpg.so: undefined reference to=20
`PGTYPESnumeric_from_asc'
/usr/local/pgsql/lib/libecpg.so: undefined reference to `PGTYPESdate_to_asc'
/usr/local/pgsql/lib/libecpg.so: undefined reference to=20
`PGTYPESinterval_from_asc'
/usr/local/pgsql/lib/libecpg.so: undefined reference to=20
`PGTYPESinterval_to_asc'
/usr/local/pgsql/lib/libecpg.so: undefined reference to=20
`PGTYPEStimestamp_from_asc'
/usr/local/pgsql/lib/libecpg.so: undefined reference to `PGTYPESdate_from_a=
sc'
/usr/local/pgsql/lib/libecpg.so: undefined reference to `PGTYPESnumeric_cop=
y'
/usr/local/pgsql/lib/libecpg.so: undefined reference to `PGTYPESinterval_co=
py'
/usr/local/pgsql/lib/libecpg.so: undefined reference to=20
`PGTYPEStimestamp_to_asc'
/usr/local/pgsql/lib/libecpg.so: undefined reference to=20
`PGTYPESnumeric_to_asc'
collect2: ld returned 1 exit status

Is there something obvious I am doing wrong here? Is there something borked=
 in=20
my build environment? I've attached my test.pgc.

Regards, Philip Yarra.
--------------Boundary-00=_4S7Q5YSFK1A28XT22I6D
Content-Type: text/x-csrc;
  charset="iso-8859-1";
  name="test.pgc"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment; filename="test.pgc"

#include <stdio.h>

int main(int argc, char *argv[])
{

	EXEC SQL BEGIN DECLARE SECTION;
		char *target = "bob@snode5";
		char *user = "philip";
		char *message = "It came from embedded C - again!";
		char *pquery = "INSERT INTO test (message) VALUES(?)";
		
	EXEC SQL END DECLARE SECTION;

	if(argv[1] != NULL)
		message = argv[1];

	EXEC SQL WHENEVER sqlerror sqlprint;

	EXEC SQL CONNECT TO :target USER :user;
	/*EXEC SQL SET AUTOCOMMIT TO ON; */

	EXEC SQL PREPARE stmt_id FROM :pquery;
	EXEC SQL EXECUTE stmt_id USING :message;
	EXEC SQL COMMIT;
	EXEC SQL FREE stmt_id;	
	EXEC SQL DISCONNECT ALL;

}

--------------Boundary-00=_4S7Q5YSFK1A28XT22I6D--