ports/79165: [PATCH] databases/postgresql-server: Add option from query hierarchy "CONNECT BY"

[Marcos Tischer Vallim]

>Number:         79165
>Category:       ports
>Synopsis:       [PATCH] databases/postgresql-server: Add option from query hierarchy "CONNECT BY"
>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:   Wed Mar 23 18:10:02 GMT 2005
>Closed-Date:
>Last-Modified:
>Originator:     Marcos Tischer Vallim
>Release:        FreeBSD 5.3-RELEASE-p5 i386
>Organization:
>Environment:
System: FreeBSD hidrogenio.widesoft.com.br 5.3-RELEASE-p5 FreeBSD 5.3-RELEASE-p5 #1: Mon Mar 21 07:26:05 BRT 2005
>Description:
Add a patch wrote by Evgen Potemkin, which allows PgSQL to make hierarchical queries a la Oracle do.


This patch is optional and selected with one more OPTION

Port maintainer (girgen at FreeBSD.org) is cc'd.

Generated with FreeBSD Port Tools 0.63
>How-To-Repeat:
>Fix:

--- postgresql-server-8.0.1_3.patch begins here ---
diff -ruN --exclude=CVS /usr/ports/databases/postgresql80-server.orig/Makefile /usr/ports/databases/postgresql80-server/Makefile
--- /usr/ports/databases/postgresql80-server.orig/Makefile	Sat Mar 19 00:51:45 2005
+++ /usr/ports/databases/postgresql80-server/Makefile	Wed Mar 23 11:45:41 2005
@@ -88,6 +88,13 @@
 #  to run regression tests:
 OPTIONS+=	TESTS "Allows the use of a \"check\" target (server)" off
 OPTIONS+=	DEBUG "Builds with debugging symbols" off
+OPTIONS+=       HIER "Builds with query hierarchy (server)" off
+
+.  if defined(SERVER_ONLY) && defined(WITH_HIER)
+PATCH_SITES+=	http://gppl.moonbone.ru/:hier801054
+PATCHFILES+=	hier-Pg8.0.1-0.5.4.diff.gz:hier801054
+PATCH_DIST_STRIP+=	-p1
+.  endif
 
 .  if defined(SERVER_ONLY) && defined(WITH_PAM)
 CONFIGURE_ARGS+=--with-pam
--- postgresql-server-8.0.1_3.patch ends here ---

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