During the configure phase, I'm seeing the following:
checking for PgSQL include directory... configure: error: Didn't find the PgSQL include dir in '/usr/local/pgsql/include/pgsql /usr/local/include/postgresql/ /usr/local/include /opt/pgsql/include/pgsql /opt/pgsql/include /usr/include/pgsql/ /usr/include/postgresql'
/usr/include/postgresql exists but the header files now seem to live in /usr/include/postgresql/server. The configure.in seems a little opaque in terms of adding to the possible header locations.
I'm using RHEL4 and the pgsql rpms from the webapps channel (8.1.3)
On Fedora 6, libpq-fe.h is installed in /usr/include, I guess it's the same for RHEL4. Don't forget to install the postgresql-devel package. You can tell configure where to find the postgresql headers with .configure --with-modules="gmysql" --with-pgsql-includes=/usr/include.
.configure --with-modules="gmysql" --with-pgsql-includes=/usr/include
Maybe Bert can add /usr/include to the list of locations where autoconf searches for the postgres headers.
Fixed by commit 998