[pgsql-ogr-fdw] 02/02: Initial release (Closes: #856538).

Michael Fladischer fladi at moszumanska.debian.org
Thu Mar 2 09:01:09 UTC 2017


This is an automated email from the git hooks/post-receive script.

fladi pushed a commit to branch master
in repository pgsql-ogr-fdw.

commit ce00af77ff36df8464de80b85776ca5627f79378
Author: Michael Fladischer <FladischerMichael at fladi.at>
Date:   Thu Mar 2 09:55:41 2017 +0100

    Initial release (Closes: #856538).
---
 debian/changelog             |  5 +++++
 debian/compat                |  1 +
 debian/control               | 41 +++++++++++++++++++++++++++++++++++++++++
 debian/control.in            | 40 ++++++++++++++++++++++++++++++++++++++++
 debian/copyright             | 31 +++++++++++++++++++++++++++++++
 debian/patches/install.patch | 20 ++++++++++++++++++++
 debian/patches/series        |  2 ++
 debian/patches/typos.patch   | 23 +++++++++++++++++++++++
 debian/pgversions            |  2 ++
 debian/rules                 | 17 +++++++++++++++++
 debian/source/format         |  1 +
 debian/source/options        |  7 +++++++
 debian/watch                 |  4 ++++
 13 files changed, 194 insertions(+)

diff --git a/debian/changelog b/debian/changelog
new file mode 100644
index 0000000..dbb9d6a
--- /dev/null
+++ b/debian/changelog
@@ -0,0 +1,5 @@
+pgsql-ogr-fdw (1.0.2-1) unstable; urgency=low
+
+  * Initial release (Closes: #856538).
+
+ -- Michael Fladischer <fladi at debian.org>  Thu, 02 Mar 2017 08:58:57 +0100
diff --git a/debian/compat b/debian/compat
new file mode 100644
index 0000000..f599e28
--- /dev/null
+++ b/debian/compat
@@ -0,0 +1 @@
+10
diff --git a/debian/control b/debian/control
new file mode 100644
index 0000000..109b4a1
--- /dev/null
+++ b/debian/control
@@ -0,0 +1,41 @@
+Source: pgsql-ogr-fdw
+Section: database
+Priority: extra
+Maintainer: Debian GIS Project <pkg-grass-devel at lists.alioth.debian.org>
+Uploaders: Michael Fladischer <fladi at debian.org>
+Build-Depends: debhelper (>= 10),
+               libgdal-dev,
+               postgresql-server-dev-all
+Standards-Version: 3.9.8
+Vcs-Browser: https://anonscm.debian.org/cgit/pkg-grass/pgsql-ogr-fdw.git
+Vcs-Git: https://anonscm.debian.org/git/pkg-grass/pgsql-ogr-fdw.git
+Homepage: https://github.com/pramsey/pgsql-ogr-fdw
+
+Package: postgresql-9.6-ogr-fdw
+Architecture: any
+Depends: postgresql-9.6, ${misc:Depends}, ${shlibs:Depends}
+Description: PostgreSQL foreign data wrapper for OGR
+ OGR is the vector half of the GDAL spatial data access library. It allows
+ access to a large number of GIS data formats using a simple C API for data
+ reading and writing. Since OGR exposes a simple table structure and PostgreSQL
+ foreign data wrappers allow access to table structures, the fit seems pretty
+ perfect.
+ .
+ This implementation currently has the following limitations:
+  * Only non-spatial query restrictions are pushed down to the OGR driver.
+    PostgreSQL foreign data wrappers support delegating portions of the SQL
+    query to the underlying data source, in this case OGR. This implementation
+    currently pushes down only non-spatial query restrictions, and only for the
+    small subset of comparison operators (>, <, <=, >=, =) supported by OGR.
+  * Spatial restrictions are not pushed down. OGR can handle basic bounding box
+    restrictions and even (for some drivers) more explicit intersection
+    restrictions, but those are not passed to the OGR driver yet.
+  * OGR connections every time Rather than pooling OGR connections, each query
+    makes (and disposes of) two new ones, which seems to be the largest
+    performance drag at the moment for restricted (small) queries.
+  * All columns are retrieved every time. PostgreSQL foreign data wrappers don't
+    require all columns all the time, and some efficiencies can be gained by
+    only requesting the columns needed to fulfill a query. This would be a
+    minimal efficiency improvement, but can be removed given some development
+    time, since the OGR API supports returning a subset of columns.
+
diff --git a/debian/control.in b/debian/control.in
new file mode 100644
index 0000000..d747501
--- /dev/null
+++ b/debian/control.in
@@ -0,0 +1,40 @@
+Source: pgsql-ogr-fdw
+Section: database
+Priority: extra
+Maintainer: Debian GIS Project <pkg-grass-devel at lists.alioth.debian.org>
+Uploaders: Michael Fladischer <fladi at debian.org>
+Build-Depends: debhelper (>= 10),
+               libgdal-dev,
+               postgresql-server-dev-all
+Standards-Version: 3.9.8
+Vcs-Browser: https://anonscm.debian.org/cgit/pkg-grass/pgsql-ogr-fdw.git
+Vcs-Git: https://anonscm.debian.org/git/pkg-grass/pgsql-ogr-fdw.git
+Homepage: https://github.com/pramsey/pgsql-ogr-fdw
+
+Package: postgresql-PGVERSION-ogr-fdw
+Architecture: any
+Depends: postgresql-PGVERSION, ${misc:Depends}, ${shlibs:Depends}
+Description: PostgreSQL foreign data wrapper for OGR
+ OGR is the vector half of the GDAL spatial data access library. It allows
+ access to a large number of GIS data formats using a simple C API for data
+ reading and writing. Since OGR exposes a simple table structure and PostgreSQL
+ foreign data wrappers allow access to table structures, the fit seems pretty
+ perfect.
+ .
+ This implementation currently has the following limitations:
+  * Only non-spatial query restrictions are pushed down to the OGR driver.
+    PostgreSQL foreign data wrappers support delegating portions of the SQL
+    query to the underlying data source, in this case OGR. This implementation
+    currently pushes down only non-spatial query restrictions, and only for the
+    small subset of comparison operators (>, <, <=, >=, =) supported by OGR.
+  * Spatial restrictions are not pushed down. OGR can handle basic bounding box
+    restrictions and even (for some drivers) more explicit intersection
+    restrictions, but those are not passed to the OGR driver yet.
+  * OGR connections every time Rather than pooling OGR connections, each query
+    makes (and disposes of) two new ones, which seems to be the largest
+    performance drag at the moment for restricted (small) queries.
+  * All columns are retrieved every time. PostgreSQL foreign data wrappers don't
+    require all columns all the time, and some efficiencies can be gained by
+    only requesting the columns needed to fulfill a query. This would be a
+    minimal efficiency improvement, but can be removed given some development
+    time, since the OGR API supports returning a subset of columns.
diff --git a/debian/copyright b/debian/copyright
new file mode 100644
index 0000000..97075bb
--- /dev/null
+++ b/debian/copyright
@@ -0,0 +1,31 @@
+Format: https://www.debian.org/doc/packaging-manuals/copyright-format/1.0/
+Upstream-Name: pgsql-ogr-fdw
+Upstream-Contact: Paul Ramsey <pramsey at cleverelephant.ca>
+Source: https://github.com/pramsey/pgsql-ogr-fdw
+
+Files: *
+Copyright: 2014, Paul Ramsey <pramsey at cleverelephant.ca>
+License: Expat
+
+Files: debian/*
+Copyright: 2017, Michael Fladischer <fladi at debian.org>
+License: Expat
+
+License: Expat
+ Permission is hereby granted, free of charge, to any person obtaining a copy of
+ this software and associated documentation files (the "Software"), to deal in
+ the Software without restriction, including without limitation the rights to
+ use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies
+ of the Software, and to permit persons to whom the Software is furnished to do
+ so, subject to the following conditions:
+ .
+ The above copyright notice and this permission notice shall be included in all
+ copies or substantial portions of the Software.
+ .
+ THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
+ IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
+ FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
+ AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
+ LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
+ OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
+ SOFTWARE.
diff --git a/debian/patches/install.patch b/debian/patches/install.patch
new file mode 100644
index 0000000..95119cc
--- /dev/null
+++ b/debian/patches/install.patch
@@ -0,0 +1,20 @@
+Description: Fix installation of ogr_fdw_info binary.
+ It would get installed with the name of the binary direcory itself instead of
+ bin/ogr_fdw_info.
+Last-Update: 2017-02-19
+Author: Michael Fladischer <fladi at debian.org>
+Forwarded: no
+
+Index: postgresql-ogr-fdw/Makefile
+===================================================================
+--- postgresql-ogr-fdw.orig/Makefile	2017-02-12 21:30:23.052413721 +0100
++++ postgresql-ogr-fdw/Makefile	2017-02-19 19:16:44.736277938 +0100
+@@ -44,7 +44,7 @@
+ 	rm -f ogr_fdw_info$(X) ogr_fdw_info.o stringbuffer.o
+ 
+ install-exe: all
+-	$(INSTALL_PROGRAM) ogr_fdw_info$(X) '$(DESTDIR)$(bindir)'
++	$(INSTALL_PROGRAM) -D ogr_fdw_info$(X) '$(DESTDIR)$(bindir)/ogr_fdw_info'
+ 
+ all: ogr_fdw_info$(X)
+ 
diff --git a/debian/patches/series b/debian/patches/series
new file mode 100644
index 0000000..10637e4
--- /dev/null
+++ b/debian/patches/series
@@ -0,0 +1,2 @@
+typos.patch
+install.patch
diff --git a/debian/patches/typos.patch b/debian/patches/typos.patch
new file mode 100644
index 0000000..fdc5dfa
--- /dev/null
+++ b/debian/patches/typos.patch
@@ -0,0 +1,23 @@
+From 5becc49208462f65258cb57d4fb28c0ed0536d7b Mon Sep 17 00:00:00 2001
+From: Michael Fladischer <FladischerMichael at fladi.at>
+Date: Mon, 13 Feb 2017 09:40:54 +0100
+Subject: [PATCH] Fix typo conect -> connect.
+
+This was spotted by lintian during a Debian package build.
+---
+ ogr_fdw_info.c | 2 +-
+ 1 file changed, 1 insertion(+), 1 deletion(-)
+
+diff --git a/ogr_fdw_info.c b/ogr_fdw_info.c
+index 4a59041..5bf2b1b 100644
+--- a/ogr_fdw_info.c
++++ b/ogr_fdw_info.c
+@@ -154,7 +154,7 @@ ogrListLayers(const char *source)
+ 	
+ 	if ( ! ogr_ds )
+ 	{
+-		CPLError(CE_Failure, CPLE_AppDefined, "Could not conect to source '%s'", source);
++		CPLError(CE_Failure, CPLE_AppDefined, "Could not connect to source '%s'", source);
+ 		return OGRERR_FAILURE; 
+ 	}
+ 
diff --git a/debian/pgversions b/debian/pgversions
new file mode 100644
index 0000000..c46c837
--- /dev/null
+++ b/debian/pgversions
@@ -0,0 +1,2 @@
+# Extension support is required.
+9.3+
diff --git a/debian/rules b/debian/rules
new file mode 100755
index 0000000..4ba6340
--- /dev/null
+++ b/debian/rules
@@ -0,0 +1,17 @@
+#!/usr/bin/make -f
+
+# Rebuild debian/control from debian/control.in
+include /usr/share/postgresql-common/pgxs_debian_control.mk
+
+%:
+	dh $@
+
+override_dh_auto_build:
+	+pg_buildext build build-%v
+
+override_dh_auto_install:
+	+pg_buildext install build-%v postgresql-%v-ogr-fdw
+
+override_dh_auto_clean:
+	+pg_buildext clean build-%v
+	rm -rf results
diff --git a/debian/source/format b/debian/source/format
new file mode 100644
index 0000000..163aaf8
--- /dev/null
+++ b/debian/source/format
@@ -0,0 +1 @@
+3.0 (quilt)
diff --git a/debian/source/options b/debian/source/options
new file mode 100644
index 0000000..2fe568c
--- /dev/null
+++ b/debian/source/options
@@ -0,0 +1,7 @@
+## This file was written by cme command.
+## You can run 'cme edit dpkg' to modify this file.
+## You may also modify the content of this file with your favorite editor.
+
+# ignore some files only in git
+
+extend-diff-ignore=".*/git-tag-release|.*/git-version"
diff --git a/debian/watch b/debian/watch
new file mode 100644
index 0000000..a1be883
--- /dev/null
+++ b/debian/watch
@@ -0,0 +1,4 @@
+version=3
+opts=filenamemangle=s/.*\/v([\d\.]+.*)$/pgsql-ogr-fdw-$1/ \
+https://github.com/pramsey/pgsql-ogr-fdw/releases \
+/pramsey/pgsql-ogr-fdw/archive/v([\d\.]+)\.tar\.gz

-- 
Alioth's /usr/local/bin/git-commit-notice on /srv/git.debian.org/git/pkg-grass/pgsql-ogr-fdw.git



More information about the Pkg-grass-devel mailing list