Re: [PHP] Some undefined function errors - Mailing list pgsql-general

From Fernando
Subject Re: [PHP] Some undefined function errors
Date
Msg-id 4BF55070.7050207@ggtours.ca
Whole thread Raw
In response to Re: [PHP] Some undefined function errors  (Giancarlo Boaron <gboaron@yahoo.com.br>)
List pgsql-general
Sorry I miss read the question.

It does seem that php is not picking up the pg module and cannot find the functions.

I assume Postgresql is in fact installed at /usr/local/pgsql.  If you run phpinfo(); can you see that PG is installed?

On 20/05/2010 10:46, Giancarlo Boaron wrote:
I make the function call in a php file. I'm not using stored procedures.
 
If I create an empty php file and put only some of these functions, Apache reports de 'call to undefined function XXX'.

--- Em qui, 20/5/10, Fernando <fernando@ggtours.ca> escreveu:

De: Fernando <fernando@ggtours.ca>
Assunto: Re: [GENERAL] [PHP] Some undefined function errors
Para: pgsql-general@postgresql.org
Data: Quinta-feira, 20 de Maio de 2010, 11:25

Are you calling store procedures that return cursors?  I had this problem with cursors because the transaction gets committed and the cursor closed after they return.  Mind you I had the problem on .NET using npgsql, so I might be way off.

Cheers


On 20/05/2010 10:05, Giancarlo Boaron wrote:
Hi all.

Recently, I wrote an email about the problem I was having with some Postgres functions that when those functions were called, I received the following error: "Call to undefined function <function_name>".

After some answers, I decided to rebuild a brand new linux virtual machine with Apache + PHP + Postgres, but I still get this annoying error messege with some functions like pg_prepare() and pg_escape_string().

I compiled Postgres with --without-readline option.
I compiled PHP with --with-apxs2=/usr/local/apache2/bin/apxs and --with-pgsql=/usr/local/pgsql/

And the compilation process has no errors.

What am I doing wrong? Do I have to change something in php_config.h file? If so, what do I have to change?

Thank you.

     
 

 

pgsql-general by date:

Previous
From: Giancarlo Boaron
Date:
Subject: Re: [PHP] Some undefined function errors
Next
From: Teddy Limousin
Date:
Subject: Re: setting contrib lo visible to all schemas