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 run the daemon process as 'root'. Thank you for some help. --- Em qui, 20/5/10, Fernando <fernando@xxxxxxxxxx> escreveu: > De: Fernando <fernando@xxxxxxxxxx> > Assunto: Re: [PHP] Some undefined function errors > Para: php-general@xxxxxxxxxxxxx > 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@xxxxxxxxxx>/* > escreveu: > > > > > > De: Fernando <fernando@xxxxxxxxxx> > > Assunto: Re: [PHP] > Some undefined function errors > > Para: pgsql-general@xxxxxxxxxxxxxx > > 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. > >> > >> > >> > >> > >> > > > > > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
