Re: [PHP] Some undefined function errors

From: Fernando <fernando(at)ggtours(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [PHP] Some undefined function errors
Date: 2010-05-20 15:08:32
Message-ID: 4BF55070.7050207@ggtours.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

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(at)ggtours(dot)ca>/* escreveu:
>
>
> De: Fernando <fernando(at)ggtours(dot)ca>
> Assunto: Re: [GENERAL] [PHP] Some undefined function errors
> Para: pgsql-general(at)postgresql(dot)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.
>>
>>
>>
>>
>>
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Teddy Limousin 2010-05-20 15:16:21 Re: setting contrib lo visible to all schemas
Previous Message Giancarlo Boaron 2010-05-20 14:46:33 Re: [PHP] Some undefined function errors

Browse pgsql-novice by date

  From Date Subject
Next Message Jim Lucas 2010-05-20 16:04:19 Re: [PHP] Some undefined function errors
Previous Message Giancarlo Boaron 2010-05-20 14:46:33 Re: [PHP] Some undefined function errors