Re: [Sqlrelay-discussion] sqlrelay 0.38 compile error on Centos 4.4

[David M. <dav...@fi...>]

It looks like in postgresql 7.4, the PQprepare function didn't exist,
rather you had to manually PQexecute a "PREPARE ..." query and then you
could call PQexecPrepared on it.

I'll update the code to support that.

In the mean time, you can fix the problem by editing the config.h file
which is generated by the configure script and change the line:

#define HAVE_POSTGRESQL_PQEXECPREPARED 1

to

#undef HAVE_POSTGRESQL_PQEXECPREPARED

and run the make again.

This will remove support for prepared queries in postgres.  The only
other option is to upgrade to postgresql 8.

Dave

On Fri, 2006-12-29 at 16:48 +0700, Nguyen Thai Ha wrote:
> I compiled sqlrelay 0.38 with rudiments 0.30, at stage of linking
> postgresql libraries, g++ thrown this error:
> 
> make -C postgresql all
> make[3]: Entering directory
> `/root/sqlrelay-0.38/src/connections/postgresql' 
> /bin/sh ../../../libtool --mode=compile g++ -Wall -pipe  -pthread
> -I./ -I../../../ -I../../../src/common -I../../../src/util
> -I../../../src/connection -I/usr/local/firstworks/include -pthread
> -I../../../src/api/c++/include -c postgresqlconnection.C -o
> postgresqlconnection.lo
>  g++ -Wall -pipe -pthread -I./ -I../../../ -I../../../src/common
> -I../../../src/util -I../../../src/connection
> -I/usr/local/firstworks/include -pthread -I../../../src/api/c
> ++/include -c postgresqlconnection.C  -fPIC -DPIC
> -o .libs/postgresqlconnection.o
> postgresqlconnection.C: In member function `virtual bool
> postgresqlcursor::prepareQuery(const char*, uint32_t)':
> postgresqlconnection.C:233: error: `PQprepare' was not declared in
> this scope 
> postgresqlconnection.C:233: warning: unused variable 'PQprepare'
> make[3]: *** [postgresqlconnection.lo] Error 1
> make[3]: Leaving directory
> `/root/sqlrelay-0.38/src/connections/postgresql'
> make[2]: *** [all] Error 2 
> make[2]: Leaving directory `/root/sqlrelay-0.38/src/connections'
> make[1]: *** [all] Error 2
> make[1]: Leaving directory `/root/sqlrelay-0.38/src'
> make: *** [all] Error 2
> 
> I used Centos 4.4 version of  postgresql (that is 7.4.13) 
> 
> Please help ! Thanks
> 
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________ Sqlrelay-discussion mailing list Sql...@li... https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion