Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 04FBA9FB5B6 for ; Wed, 7 Mar 2007 07:22:29 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 91734-01 for ; Wed, 7 Mar 2007 07:22:20 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.240]) by postgresql.org (Postfix) with ESMTP id D405C9FB592 for ; Wed, 7 Mar 2007 07:22:23 -0400 (AST) Received: by an-out-0708.google.com with SMTP id c24so99785ana for ; Wed, 07 Mar 2007 03:22:22 -0800 (PST) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=emJmhAZcTwk/pXgNFRsWAJgm6c9d9NBr70bvm14IaQeDI2EUBVY1DWxY3JtV6epP3zy90HSyy/Bii/QAD2KWH05SwjCeeHwq95nKv9FmR2NM+Ct4KH4c7gTxQ3XFbFKTGsKoLuk8HE20EYbEOz3+cO8PcH0YDjNR1t6ckFE6v4Y= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=EZTaiUQ3Vi/lAW5A0bPTutAI13Txm390Ng7He90PwgRzePHZ/lWJktTXBWQR1G/3j3y6s7eXXGBSvd9GieRCcynjJ78gMNwS0WQWyZeXsRsMOvF2d7KXzd0lANcBmUFpwxywonnSbHwnPXO5zrcOK0p/XAu+f2S1hM0g8DNGzmc= Received: by 10.100.47.6 with SMTP id u6mr4240329anu.1173266542620; Wed, 07 Mar 2007 03:22:22 -0800 (PST) Received: by 10.100.165.1 with HTTP; Wed, 7 Mar 2007 03:22:22 -0800 (PST) Message-ID: Date: Wed, 7 Mar 2007 12:22:22 +0100 From: mikie To: pgsql-php@postgresql.org Subject: Re: Undefined function pg_escape_bytea() despite good PG version In-Reply-To: <397592.36072.qm@web52901.mail.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <20070307090739.C502237B56A@mx3.hub.org> <397592.36072.qm@web52901.mail.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/29 X-Sequence-Number: 3741 2007/3/7, Thomas Woerly : > 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...