Re: undefined function pg_connect()

[JamieC <EndingRight@xxxxxxxxx>]

SOLVED !!!

Yes, postgres is already installed.  (My problem started when I upgraded from PHP 5.2.3 to 5.2.6.)

After some more digging around, I found the following:

Bug #44905
   PHP 5.2.6 fails to load PostgreSQL related libraries

http://bugs.php.net/bug.php?id=44905

In the documentation for this bug is the circumvention which is 
"Simply add your PostgreSQL bin directory ("C:\Program
Files\PostgreSQL\8.3\bin" on my system) to your system path."
I did this and the problem disappeared.

Thank you for your help.
jfc

2008/11/21 Lester Caine <lester@xxxxxxxxxxx>

James Chubb wrote:

Hello,

I wonder if someone could help me resolve this problem.

Today, after upgrading from PHP 5.2.3. <http://5.2.3.> to 5.2.6, this little program:

<?php
       $db = pg_connect('host=localhost dbname=xxxx user=chubb password=yyyyyy')
           or die('Could not connect: ' . pg_last_error());
?>

is now getting this error:

*Fatal error*: Call to undefined function pg_connect() in *C:\Inetpub\cu\code_tests\db_connect.php* on line *2

*
According to phpinfo() ...

Server API: ISAPI
Loaded Configuration File: C:\Program Files\PHP\php.ini
PHP Extension: 20060613
Path environment variable: C:\Program Files\PHP\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\QuickTime\QTSystem\

But is it showing pgsql installed?

In the php.ini file, I do have:
extension=php_pgsql.dll

And on my system, I do have:
C:\Program Files\PHP\ext\php_pgsql.dll   (98,368   2008-05-02 18:07)

I am running Windows/XP and IIS 5.1.

What is causing this problem?

I would suspect it's not finding postgres so php_pgsql is not actually being installed when php starts.

--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/lsces/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php