ports/137039: patch to allow databases/pgpool-II build with postgresql 8.4

[Sevan Janiyan]

>Number:         137039
>Category:       ports
>Synopsis:       patch to allow databases/pgpool-II build with postgresql 8.4
>Confidential:   no
>Severity:       non-critical
>Priority:       low
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          change-request
>Submitter-Id:   current-users
>Arrival-Date:   Thu Jul 23 18:00:06 UTC 2009
>Closed-Date:
>Last-Modified:
>Originator:     Sevan Janiyan
>Release:        7.2
>Organization:
Venture 37 Ltd
>Environment:
>Description:
patch to allow v2.2.2 to build with postgresql 8.4, obtained from http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool-II/sql/pgpool-recovery/pgpool-recovery.c?r1=1.6&r2=1.6.2.1

tested on systems using postgresql v8.2 & v8.4
>How-To-Repeat:

>Fix:


Patch attached with submission follows:

diff -urN databases/pgpool-II.orig/Makefile databases/pgpool-II/Makefile
--- databases/pgpool-II.orig/Makefile	2009-07-23 17:34:54.000000000 +0000
+++ databases/pgpool-II/Makefile	2009-07-23 17:38:44.000000000 +0000
@@ -7,6 +7,7 @@
 
 PORTNAME=	pgpool-II
 PORTVERSION=	2.2.2
+PORTREVISION=	1
 CATEGORIES=	databases
 MASTER_SITES=	http://pgfoundry.org/frs/download.php/2191/
 
diff -urN databases/pgpool-II.orig/files/patch-sql-pgpool-recovery_pgpool-recovery.c databases/pgpool-II/files/patch-sql-pgpool-recovery_pgpool-recovery.c
--- databases/pgpool-II.orig/files/patch-sql-pgpool-recovery_pgpool-recovery.c	1970-01-01 00:00:00.000000000 +0000
+++ databases/pgpool-II/files/patch-sql-pgpool-recovery_pgpool-recovery.c	2009-07-23 17:32:40.000000000 +0000
@@ -0,0 +1,10 @@
+--- /usr/ports/databases/pgpool-II/work/pgpool-II-2.2.2/sql/pgpool-recovery/pgpool-recovery.c.orig	2009-07-23 17:30:52.000000000 +0000
++++ /usr/ports/databases/pgpool-II/work/pgpool-II-2.2.2/sql/pgpool-recovery/pgpool-recovery.c	2009-07-23 17:31:34.000000000 +0000
+@@ -23,6 +23,7 @@
+ #include "miscadmin.h"
+ #include "executor/spi.h"
+ #include "funcapi.h"
++#include "utils/builtins.h"	/* PostgreSQL 8.4 needs this for textout */
+ 
+ #define REMOTE_START_FILE "pgpool_remote_start"
+ 


>Release-Note:
>Audit-Trail:
>Unformatted: