Yes. Phpinfo() tells me it's ok:
pgsql
PostgreSQL Support enabled
PostgreSQL(libpq) Version 8.4.4
Multibyte character support disabled
SSL support enabled
Active Persistent Links 0
Active Links 0
Directive Local Value Master Value
pgsql.allow_persistent On On
pgsql.auto_reset_persistent Off Off
pgsql.ignore_notice Off Off
pgsql.log_notice Off Off
pgsql.max_links Unlimited Unlimited
pgsql.max_persistent Unlimited Unlimited
My PHP version is 5.3.2.
My PostgreSQL version is 8.4.4 and I'm running the server under the restrict 'postgres' user privileges since I can't
runthe daemon process as 'root'.
Thank you for some help.
--- Em qui, 20/5/10, Fernando <fernando@ggtours.ca> escreveu:
> De: Fernando <fernando@ggtours.ca>
> Assunto: Re: [PHP] Some undefined function errors
> Para: php-general@lists.php.net
> Data: Quinta-feira, 20 de Maio de 2010, 12:23
> 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.
> >>
> >>
> >>
> >>
> >>
> >
> >
>
