Page 1 of 1

PGSQL Will NOT work

Posted: Fri Nov 07, 2008 3:55 am
by swraman
Fatal error: Call to undefined function pg_connect()

i have tried everything for the past 5 hours.

I NEED pgsql and PHP 5.2 for a project.

I used to use apache2triad ut it only has php 5.1.

I set up a new server up I get the same error.

I have the php_pgsql.dll extension line uncommented each time I tried it. Still same error. I restarted Apache each time I made a change.

Any help?

Tanks

Re: PGSQL Will NOT work

Posted: Fri Nov 07, 2008 4:11 am
by VladSun
Sure :)
Add the path to PG SQL client DLLs (e.g. "bin" directory in your PG SQL install directory) to Windows PATH environment variable ;)
Also, it's good for you to have a look at Apache error log files from time to time ;)

Re: PGSQL Will NOT work

Posted: Fri Nov 07, 2008 11:21 am
by swraman
Still a no go. :(

Any other advice? Thanks

Re: PGSQL Will NOT work

Posted: Fri Nov 07, 2008 11:55 am
by VladSun
Could you post the output of

Code: Select all

PATH
run into MS Console?
Did you restart Apache service?
What do you have in your Apache error logs?

Re: PGSQL Will NOT work

Posted: Fri Nov 07, 2008 2:35 pm
by swraman
Thanks, I got it :)

I just started over from the eginning and the db connects now :)

ut I have nother question, the script I have isnt working and I want to know if it created the required entries in the db, is there any way to actually view the actual data in the tales of the DB?

in pgAdmin, I can see all the tables and their columns, but it says there are 0 rows...does that mean that there is no data in the tale?

Thanks

Re: PGSQL Will NOT work

Posted: Fri Nov 07, 2008 4:58 pm
by swraman
OK I got that sorted out too. Thanks for the help :)