From: mikie <mikie.pl@gmail.com>
To: pgsql-php@postgresql.org
Subject: Re: Undefined function pg_escape_bytea() despite good PG version
Date: Wed, 7 Mar 2007 12:22:22 +0100
Message-ID: <ca35ce500703070322g7bff3df6y1467f3698e7d81dd@mail.gmail.com> (raw)
In-Reply-To: <397592.36072.qm@web52901.mail.yahoo.com>
References: <20070307090739.C502237B56A@mx3.hub.org>
<397592.36072.qm@web52901.mail.yahoo.com>
2007/3/7, Thomas Woerly <yorgat@yahoo.com>:
> 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...
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: mikie.pl@gmail.com
Subject: Re: Undefined function pg_escape_bytea() despite good PG version
In-Reply-To: <ca35ce500703070322g7bff3df6y1467f3698e7d81dd@mail.gmail.com>
References: <20070307090739.C502237B56A@mx3.hub.org> <397592.36072.qm@web52901.mail.yahoo.com> <ca35ce500703070322g7bff3df6y1467f3698e7d81dd@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox