ports/158599: [PATCH] databases/pgadmin3

[Rainer Hurling]

>Number:         158599
>Category:       ports
>Synopsis:       [PATCH] databases/pgadmin3
>Confidential:   no
>Severity:       non-critical
>Priority:       low
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          update
>Submitter-Id:   current-users
>Arrival-Date:   Sat Jul 02 19:00:21 UTC 2011
>Closed-Date:
>Last-Modified:
>Originator:     Rainer Hurling
>Release:        FreeBSD 9.0-CURRENT (amd64)
>Organization:
>Environment:
FreeBSD xxx.xxx.xxx 9.0-CURRENT FreeBSD 9.0-CURRENT #0: Sat Jun 25 16:04:44 CEST 2011 xxx at xxx.xxx.xx:/usr/obj/usr/src/sys/XXX amd64
>Description:
Since PR 157605 is committed (thanks to wen@), there is a gui version of 'shp2pgsql' (from databases/postgis). 'shp2pgsql-gui' can be used as standalone or within PgAdmin3 (databases/pgadmin3) to directly convert ESRI shapefiles and load them into a PostGIS enabled PostgreSQL database.

To be able to recognize 'shp2pgsql-gui', PgAdmin3 on FreeBSD also needs an entry in its plugins.ini file.

>How-To-Repeat:
After patching 'plugins.ini' you will find a new entry 'PostGIS Shapefile and DBF loader' in the Plugins menu of PgAdmin3.
>Fix:


Patch attached with submission follows:

diff -Naur pgadmin3.orig/Makefile pgadmin3/Makefile
--- pgadmin3.orig/Makefile	2010-10-05 18:19:04.000000000 +0200
+++ pgadmin3/Makefile	2011-07-02 20:05:26.000000000 +0200
@@ -7,6 +7,7 @@
 
 PORTNAME=	pgadmin3
 PORTVERSION=	1.12.0
+PORTREVISION=	1
 CATEGORIES=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL}
 MASTER_SITE_SUBDIR=	pgadmin3/release/v${PORTVERSION}/src
diff -Naur pgadmin3.orig/files/patch-pgadmin_plugins.ini pgadmin3/files/patch-pgadmin_plugins.ini
--- pgadmin3.orig/files/patch-pgadmin_plugins.ini	1970-01-01 01:00:00.000000000 +0100
+++ pgadmin3/files/patch-pgadmin_plugins.ini	2011-07-02 20:16:31.000000000 +0200
@@ -0,0 +1,17 @@
+--- pgadmin/plugins.ini.orig	2010-07-28 19:43:18.000000000 +0200
++++ pgadmin/plugins.ini	2011-07-02 20:15:34.000000000 +0200
+@@ -167,3 +167,14 @@
+ ; AppliesTo=database
+ ; SetPassword=Yes
+ 
++;
++; PostGIS shp2pgsql-gui (Unix):
++;
++Title=PostGIS Shapefile and DBF loader
++Command="$$PGBINDIR/shp2pgsql-gui" -h $$HOSTNAME -p $$PORT -U $$USERNAME -d $$DATABASE
++Description=Open a PostGIS ESRI Shapefile or Plain dbf loader to the current database.
++KeyFile=$$PGBINDIR/shp2pgsql-gui
++Platform=unix
++ServerType=postgresql
++Database=Yes
++SetPassword=Yes


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