Yes, im pretty new to postgresql. To be more precise, not only to postgresql but also to Mysql and MS-SQL.
My current setup is apache2.0, PHP4 (PHP Version 4.0.3pl1 to be precise) and postgresql 7.4.1 on a Windows 2003 Server.
Actually the postgresql came with cygwin2.0.
I actually was able to create a few tables, triggers and function but to my horror i am not able to connect to my db with pg_connect().
Yes, i get the "Fatal error: Call to undefined function: pg_connect()" error.
I found quite a few "solutions" and basicly it said to recompile PHP.
From what i understand is that when PHP is installed on windows, it has all "options" enabled. Even spotted a few pg_ thingies in php.ini file.
When searching for solutions something else got my attention as well. The postgres.conf file has only a few options enabled.
If i edit the postgres.conf file.. will the new settings be enabled when i create a new db in "template1=# create database <dbname>"?
On a side note,
if i do have to recompile PHP on a windows machine... i'd love to see a nice link as i've been unsuccesfull in finding a link "how to...." recompile it.
Indeed, in my php.ini the line extension=php_pgsql.dll was indeed preceded by (.
After removing it.. it still didnt work.. but after i copied the php_psql.dll into both windows and windows/system32 (prolly only needed to excist in windows/system32 but hey... i just copy pasting anyways ;P)