Re: Inquiry From Form [pgsql]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



On Thu, 15 May 2003, Mark wrote:

> I have a Raq4i and I am trying to write PHP 4 to the PostgreSQL.  But I 
> keep getting undefined function: pg_connect() .  I have the extension 
> enabled and the PHP was compiled for postgreSQL.  I do not understand 
> what is going on?

If PHP says pg_connect is undefined, then the php the RAQ is running isn't 
compiled for postgresql connectivity.

There are two common causes of this:

1:  You compiled one build of PHP, the RAQ is running on another build.

2:  You told PHP to build in postgresql connectivity, it couldn't find the 
right header file, failed, writing an error message to the screen during 
configuration, saying something along the lines of "could not find file 
xxxxx.h" skipping postgresql configuration.

PHP will then happily build and run, without postgresql capabilities.

Try this:

write a web page with this in it:

<?php
phpinfo();
?>

Look through the page to see if it mentions postgresql.  At the top will 
be a list of all the switches it was configged with.  If you have a 
--with-pgsql there, but no pgsql section in phpinfo, then the configure 
script couldn't find the right headers.  Make sure you're running a fairly 
late model version of both PHP and postgresql, as there was a bit of an 
issue about a year ago when postgresql changed the name of one of it's 
connection headers.





[Index of Archives]     [Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

  Powered by Linux