Re: Compile errors 5.1.6 --with-pgsql

[markh <mark@xxxxxxxxxxx>]

markh wrote:
> I am having trouble getting php-5.1.6 to compile with pgsql.
>
> my configuration:
> './configure' \
> '--with-mysql' \
> '--with-apxs=/usr/local/apache/bin/apxs' \
> '--with-gettext' \
> '--with-curl' \
> '--enable-safe-mode' \
> '--with-openssl' \
> '--with-pgsql=shared' \
> '--with-xml=/usr/' \
> '--with-zlib-dir=/usr/include/' \
> '--with-imap' \
> '--with-imap-ssl' \
> '--with-kerberos' \
> '--with-gd' \
> '--with-jpeg-dir=/usr/lib' \
> '--with-ttf' \
> '--with-freetype-dir=/usr/lib' \
> '--enable-gd-native-ttf' \
> '--with-imagick' \
> '--with-pspell' \
>
> Make fails with the following:
> (.. snipped to save space)
> /home/instsrc/php-5.1.6/ext/pgsql/pgsql.c:3012: error: 'PQERRORS_TERSE' 
> undeclared (first use in this function)
> /home/instsrc/php-5.1.6/ext/pgsql/pgsql.c:3012: error: 
> 'PQERRORS_DEFAULT' undeclared (first use in this function)
> /home/instsrc/php-5.1.6/ext/pgsql/pgsql.c:3012: error: 
> 'PQERRORS_VERBOSE' undeclared (first use in this function)
> /home/instsrc/php-5.1.6/ext/pgsql/pgsql.c: In function 
> 'zif_pg_result_error_field':
> /home/instsrc/php-5.1.6/ext/pgsql/pgsql.c:3668: error: 
> 'PG_DIAG_SEVERITY' undeclared (first use in this function)
> /home/instsrc/php-5.1.6/ext/pgsql/pgsql.c:3668: error: 
> 'PG_DIAG_SQLSTATE' undeclared (first use in this function)
> /home/instsrc/php-5.1.6/ext/pgsql/pgsql.c:3668: error: 
> 'PG_DIAG_MESSAGE_PRIMARY' undeclared (first use in this function)
> /home/instsrc/php-5.1.6/ext/pgsql/pgsql.c:3669: error: 
> 'PG_DIAG_MESSAGE_DETAIL' undeclared (first use in this function)
> /home/instsrc/php-5.1.6/ext/pgsql/pgsql.c:3669: error: 
> 'PG_DIAG_MESSAGE_HINT' undeclared (first use in this function)
> /home/instsrc/php-5.1.6/ext/pgsql/pgsql.c:3676: error: 
> 'PG_DIAG_STATEMENT_POSITION' undeclared (first use in this function)
> /home/instsrc/php-5.1.6/ext/pgsql/pgsql.c:3676: error: 'PG_DIAG_CONTEXT' 
> undeclared (first use in this function)
> /home/instsrc/php-5.1.6/ext/pgsql/pgsql.c:3676: error: 
> 'PG_DIAG_SOURCE_FILE' undeclared (first use in this function)
> /home/instsrc/php-5.1.6/ext/pgsql/pgsql.c:3677: error: 
> 'PG_DIAG_SOURCE_LINE' undeclared (first use in this function)
> /home/instsrc/php-5.1.6/ext/pgsql/pgsql.c:3677: error: 
> 'PG_DIAG_SOURCE_FUNCTION' undeclared (first use in this function)
> /home/instsrc/php-5.1.6/ext/pgsql/pgsql.c: In function 'php_pgsql_convert':
> /home/instsrc/php-5.1.6/ext/pgsql/pgsql.c:5018: warning: pointer targets 
> in passing argument 1 of 'PQescapeBytea' differ in signedness
> /home/instsrc/php-5.1.6/ext/pgsql/pgsql.c: In function 
> 'php_pgsql_result2array':
> /home/instsrc/php-5.1.6/ext/pgsql/pgsql.c:5596: warning: pointer targets 
> in passing argument 3 of 'php_addslashes' differ in signedness
> make: *** [ext/pgsql/pgsql.lo] Error 1
>
> This is on a debian install, with Postgresql 7.4 intalled from packages, 
> Apache 1.3.37 built from sources.
>
> Am currently running php-5.0.4 with pgsql, which built just fine.  Any 
> ideas?
> --Mark

Figured it out, duhh!  Configure was finding a very old pg_config file 
that was left over from a manual build instead of the more recently 
installed version. Guess its time to clean up this old box!
-M