Bug 79165 - [PATCH] databases/postgresql-server: Add option from query hierarchy "CONNECT BY"
Summary: [PATCH] databases/postgresql-server: Add option from query hierarchy "CONNECT...
Status: Closed FIXED
Alias: None
Product: Ports & Packages
Classification: Unclassified
Component: Individual Port(s) (show other bugs)
Version: Latest
Hardware: Any Any
: Normal Affects Only Me
Assignee: Palle Girgensohn
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-03-23 18:10 UTC by Marcos Tischer Vallim
Modified: 2005-04-14 00:18 UTC (History)
1 user (show)

See Also:

Attachments
postgresql-server-8.0.1_3.patch (794 bytes, patch)
2005-03-23 18:10 UTC, Marcos Tischer Vallim 		no flags Details | Diff
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Marcos Tischer Vallim 2005-03-23 15:59:00 UTC 
Sorry, I forgot distinfo patch, here is a new to fix it.


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 12:32:34 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
diff -ruN --exclude=CVS /usr/ports/databases/postgresql80-server.orig/distinfo /usr/ports/databases/postgresql80-server/distinfo
--- /usr/ports/databases/postgresql80-server.orig/distinfo	Thu Feb  3 07:30:26 2005
+++ /usr/ports/databases/postgresql80-server/distinfo	Wed Mar 23 12:19:58 2005
@@ -6,3 +6,5 @@
 SIZE (postgresql/postgresql-opt-8.0.1.tar.bz2) = 133466
 MD5 (postgresql/postgresql-test-8.0.1.tar.bz2) = ad7baaaf9cf417b9ddd1512f1dd7fb10
 SIZE (postgresql/postgresql-test-8.0.1.tar.bz2) = 961001
+MD5 (postgresql/hier-Pg8.0.1-0.5.4.diff.gz) = 1d410cfb38253675fee36c8f9ee655e2
+SIZE (postgresql/hier-Pg8.0.1-0.5.4.diff.gz) = 30662
diff -ruN --exclude=CVS /usr/ports/databases/postgresql80-server.orig/mail /usr/ports/databases/postgresql80-server/mail
--- /usr/ports/databases/postgresql80-server.orig/mail	Wed Dec 31 21:00:00 1969
+++ /usr/ports/databases/postgresql80-server/mail	Wed Mar 23 12:43:24 2005
@@ -0,0 +1 @@
Comment 1 Marcos Tischer Vallim 2005-03-23 18:10:02 UTC 
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@FreeBSD.org) is cc'd.

Generated with FreeBSD Port Tools 0.63
Comment 2 Thierry Thomas freebsd_committer freebsd_triage 2005-03-23 19:34:53 UTC 
Responsible Changed
From-To: freebsd-ports-bugs->girgen


Assign to maintainer.
Comment 3 Palle Girgensohn freebsd_committer freebsd_triage 2005-04-14 00:18:03 UTC 
State Changed
From-To: open->closed

Committed. Thanks!