ports/65859: [patch] port www/mod_php3 build fails w/postgresql selected

[Frank McConnell]

>Number:         65859
>Category:       ports
>Synopsis:       [patch] port www/mod_php3 build fails w/postgresql selected
>Confidential:   no
>Severity:       non-critical
>Priority:       low
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          sw-bug
>Submitter-Id:   current-users
>Arrival-Date:   Wed Apr 21 12:30:17 PDT 2004
>Closed-Date:
>Last-Modified:
>Originator:     Frank McConnell
>Release:        FreeBSD 4.9-RELEASE-p3 i386
>Organization:
Mail Abuse Prevention Systems LLC
>Environment:
System: FreeBSD scroungebox.mail-abuse.org 4.9-RELEASE-p3 FreeBSD 4.9-RELEASE-p3 #0: Tue Mar 16 16:18:06 PST 2004 root at scroungebox.mail-abuse.org:/usr/obj/usr/src/sys/GENERIC i386

	All freshly cvsup'd on Tue 16 Mar 2003.  

	PostgreSQL previously installed (from databases/postgresql-client 
	port).

>Description:

	The configure script looks for /usr/local/include/postgresql,
	and finding it (because it is present in a modern PostgreSQL 
	installation), prefers it to /usr/local for the include path.
	This prevents gcc from finding libpq-fe.h and libpq/libpq-fs.h
	when compiling internal_functions.c:
		In file included from internal_functions.c:59:
		functions/php_pgsql.h:46: libpq-fe.h: No such file or directory
		functions/php_pgsql.h:47: libpq/libpq-fs.h: No such file or directory

>How-To-Repeat:

	Attempt to build port /usr/ports/www/mod_php3.
	When the dialog is presented, de-select options for zlib and MySQL,
	and select the option for PostgreSQL.

>Fix:

	See diff for /usr/ports/www/mod_php3/files/patch-aq, below.

--- patch-aq.diff begins here ---
--- patch-aq.orig	Sun Mar  4 10:27:56 2001
+++ patch-aq	Wed Mar 17 13:39:09 2004
@@ -46,3 +46,11 @@
  fi
  
      echo $ac_n "checking for insck__getVdate in -linsck""... $ac_c" 1>&6
+@@ -9671,7 +9670,6 @@
+     PGSQL_INCDIR=$withval/include
+     test -d $withval/include/pgsql && PGSQL_INCDIR=$withval/include/pgsql
+     test -d $withval/pgsql/include && PGSQL_INCDIR=$withval/pgsql/include
+-    test -d $withval/include/postgresql && PGSQL_INCDIR=$withval/include/postgresql
+     PGSQL_LIBDIR=$withval/lib
+     test -d $withval/lib/pgsql && PGSQL_LIBDIR=$withval/lib/pgsql
+     test -d $withval/pgsql/lib && PGSQL_LIBDIR=$withval/pgsql/lib
--- patch-aq.diff ends here ---
>Release-Note:
>Audit-Trail:
>Unformatted: