Re: Undefined function pg_escape_bytea() despite good PG version

2007/3/7, Thomas Woerly <[email protected]>:
> Hello PGsql list people !
>
> My first message on this list.
>
> I am installing a collaborative platform using Apache2.0.59 / PHP4.4.2 and
> Postgre 7.4.14
>
> Everthinh works fine in the creation of tables until this for one table :
>
> Call to undefined function: pg_escape_bytea()
> in/home/demo/phpgwapi/inc/adodb/drivers/adodb-postgres64.inc.php on line 407

Can we see the line 407 of your php script adodb-postgres64.inc.php ?
This seems to be PHP related problem rather than Postgres...

> When searching the Web, some say it is due a bad version of PostgreSQL, since
> pg_escape_bytea() arrived at v.7.2.

To make things clearer: PHP function pg_escape_bytea() is available in
PHP >= 4.2.0.
This function _requires_ Postgres version minimum 7.2
Please note this is a PHP function, not Postgres.

> My Webmin and pg_config --version say I have a 7.4.14 version.
>
> I compiled PHP with this
> ./configure --with-apxs2=/usr/local/apache2/bin/apxs --with-dbase
> --with-filepro --enable-exif --with-xml --enable-ftp --with-db --enable-bcmath
> --enable-calendar --with-jpeg-dir --with-png-dir --with-gd
> --enable-gd-native-ttf --with-freetype-dir --with-gettext --with-mysql
> --with-zlib-dir --enable-trans-sid --with-imap --with-kerberos --with-imap-ssl
> --with-openssl --enable-sysvsem --enable-sysvshm --with-gettext --with-dom
> --with-mcrypt --with-iconv --enable-mbstring=all --enable-mbregex --with-gd
> --with-png-dir=/usr --with-jpeg-dir=/usr
> --with-mime-magic=/usr/share/magic.mime
> --with-pgsql=/usr/locla/pgsql/bin/pg_config

Looks fine to me...

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match