From owner-freebsd-ports-bugs@FreeBSD.ORG Sat Jul 2 19:00:22 2011 Return-Path: Delivered-To: freebsd-ports-bugs@hub.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 4EB501065670 for ; Sat, 2 Jul 2011 19:00:22 +0000 (UTC) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (freefall.freebsd.org [IPv6:2001:4f8:fff6::28]) by mx1.freebsd.org (Postfix) with ESMTP id 2319C8FC13 for ; Sat, 2 Jul 2011 19:00:22 +0000 (UTC) Received: from freefall.freebsd.org (localhost [127.0.0.1]) by freefall.freebsd.org (8.14.4/8.14.4) with ESMTP id p62J0Mg0052675 for ; Sat, 2 Jul 2011 19:00:22 GMT (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.14.4/8.14.4/Submit) id p62J0Lnh052674; Sat, 2 Jul 2011 19:00:21 GMT (envelope-from gnats) Resent-Date: Sat, 2 Jul 2011 19:00:21 GMT Resent-Message-Id: <201107021900.p62J0Lnh052674@freefall.freebsd.org> Resent-From: FreeBSD-gnats-submit@FreeBSD.org (GNATS Filer) Resent-To: freebsd-ports-bugs@FreeBSD.org Resent-Reply-To: FreeBSD-gnats-submit@FreeBSD.org, Rainer Hurling Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 6D7C51065676 for ; Sat, 2 Jul 2011 18:56:15 +0000 (UTC) (envelope-from nobody@FreeBSD.org) Received: from red.freebsd.org (red.freebsd.org [IPv6:2001:4f8:fff6::22]) by mx1.freebsd.org (Postfix) with ESMTP id 448548FC12 for ; Sat, 2 Jul 2011 18:56:15 +0000 (UTC) Received: from red.freebsd.org (localhost [127.0.0.1]) by red.freebsd.org (8.14.4/8.14.4) with ESMTP id p62IuEb6020685 for ; Sat, 2 Jul 2011 18:56:14 GMT (envelope-from nobody@red.freebsd.org) Received: (from nobody@localhost) by red.freebsd.org (8.14.4/8.14.4/Submit) id p62IuEYU020684; Sat, 2 Jul 2011 18:56:14 GMT (envelope-from nobody) Message-Id: <201107021856.p62IuEYU020684@red.freebsd.org> Date: Sat, 2 Jul 2011 18:56:14 GMT From: Rainer Hurling To: freebsd-gnats-submit@FreeBSD.org X-Send-Pr-Version: www-3.1 Cc: Subject: ports/158599: [PATCH] databases/pgadmin3 X-BeenThere: freebsd-ports-bugs@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Ports bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 02 Jul 2011 19:00:22 -0000 >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@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: