#19856 [Fbk->Opn]: missing function

ID: 19856 User updated by: cuek_saja@yahoo.com Reported By: cuek_saja@yahoo.com -Status: Feedback +Status: Open Bug Type: PostgreSQL related Operating System: Redhat Linux 7.x kernel 2.4.9-34 PHP Version: 4.2.1 New Comment: yes... # psql --version psql (PostgreSQL) 7.2.1 contains support for: readline, history, multibyte # rpm -q postgresql postgresql-7.2.1-2PGDG --- However, I remember now that I installed in kind of a weird way. Because the redhat RPMs annoyingly scatter everything instead of keeping packages intact in their own filesystem i had to create /opt/pgsql under which i have the soft links include and lib which just point to /usr/lib and /usr/include which is where the postgresql RPM installed the postgres libraries. Could I be missing something in that setup or could the rpm just not have the necessary function. (in which case upgrading isn't going to help right?) Previous Comments: ------------------------------------------------------------------------ [2002-10-10 20:08:29] sniper@php.net Please try using this CVS snapshot: http://snaps.php.net/php4-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-latest.zip Okay, seems like your posgresql libraries do not have that function. Are you SURE you have version 7.2.1 installed? If so, try the PHP snapshot above. I'm not sure if there was some bug in this in earlier PHP versions. ------------------------------------------------------------------------ [2002-10-10 18:58:18] cuek_saja@yahoo.com 1st) thanks for the speedy help It is defined but i checked config.log anyway, and there did seem to be an error. Here's a snip from the log... configure:52394: checking for PQescapeString in -lpq configure:52413: gcc -o conftest -g -O2 -DLINUX=22 -DTARGET="httpsd" -DUSE_HSREGEX -DAPACHE_SSL -Wl,-rpath,/opt/gd/lib -L/opt/gd/lib -L/opt/ pgsql/lib conftest.c -lpq -lgd -lcrypt -lresolv -lm -ldl -lnsl -lresolv -lcrypt 1>&5 /tmp/ccqMssoC.o: In function `main': /usr/local/src/php-4.2.1/configure:52409: undefined reference to `PQescapeString' collect2: ld returned 1 exit status configure: failed program was: #line 52402 "configure" #include "confdefs.h" /* Override any gcc2 internal prototype to avoid an error. */ /* We use char because int might match the return type of a gcc2 builtin and then its argument prototype would still apply. */ char PQescapeString(); int main() { PQescapeString() ; return 0; } ----- end snippit ----- Any idea what caused it? Should i just upgrade to php 4.3 and be done with it? ------------------------------------------------------------------------ [2002-10-10 18:34:16] sniper@php.net In main/php_config.h, is this defined: HAVE_PQESCAPE And if it isn't, check config.log for reason WHY the check for it fails (search it for PQescapeString) ------------------------------------------------------------------------ [2002-10-10 17:17:42] cuek_saja@yahoo.com psql (PostgreSQL) 7.2.1 ------------------------------------------------------------------------ [2002-10-10 17:16:18] cuek_saja@yahoo.com Using php v.4.2.1. All other postgres functions i've tried work but if i try to call pg_escape_string or pg_escape_bytea i get an undefined function error, like so... Fatal error: Call to undefined function: pg_escape_string() in here's my configure command, in case it helps. './configure' '--with-mysql' '--with-pgsql=/opt/pgsql' '--with-apxs=/usr/local/apache_1.3.26/bin/apxs' '--with-xml' '--with-gd=/opt/gd' '--enable-track-vars' ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=19856&edit=1