do i need to do something to get postgresSQL working with PHP?

hi,

i normally use MySQL as my backend database, but for the project i'm working on at the moment i must use postgresSQL.

i have installed postgresSQL and it is working fine, but for some reason my postgresSQL commands aren't working.

for example, this command:
$result = pg_pconnect("host=localhost dbname=infolines1 user=user1 password=password1");

is returning this error:
Fatal error: Call to undefined function: pg_pconnect() in /usr/local/apache/htdocs/mcash/db_fns.php on line 5

any one have any ideas? do i need to recompile PHP with some postgres flag set?

thanks!

You need to recompile PHP with PostgreSQL support.

./configure --with-apache=/home/sryan/apache_1.3.23 --with-mysql --with-pgsql=/usr/local/pgsql
make
make install

everything seemed to work fine... but i am still getting the same error!!

arrgh!

any ideas?

thanks