Thread: Some undefined function errors

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
getthis 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.

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.

     
 

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.

 

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
getthis 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.
>
>
>
>

Depending on what version of apache you are running, you need to make sure that
you are loading the pgsql.so file or have the psql.ini file in your
/var/www/conf/php5/ directory.

This way it knows to load pg.

--
Jim Lucas

   "Some men are born to greatness, some achieve greatness,
       and some have greatness thrust upon them."

Twelfth Night, Act II, Scene V
    by William Shakespeare