]> granicus.if.org Git - postgis/log
postgis
5 years agoRemove duplicate points with ST_AsTWKB also when apearing before min npoints Closes...
Nicklas Avén [Thu, 1 Aug 2019 08:20:13 +0000 (08:20 +0000)]
Remove duplicate points with ST_AsTWKB also when apearing before min npoints Closes #4461

git-svn-id: http://svn.osgeo.org/postgis/trunk@17654 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoHandle POINT EMPTY in shape loader/dumper
Paul Ramsey [Wed, 31 Jul 2019 21:42:20 +0000 (21:42 +0000)]
Handle POINT EMPTY in shape loader/dumper
Closes #4437

git-svn-id: http://svn.osgeo.org/postgis/trunk@17653 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoTravis: Use PG12 image by default
Raúl Marín Rodríguez [Wed, 31 Jul 2019 15:22:19 +0000 (15:22 +0000)]
Travis: Use PG12 image by default

Closes #4446

git-svn-id: http://svn.osgeo.org/postgis/trunk@17649 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoUse protobuf version to enable/disable mvt/geobuf
Paul Ramsey [Tue, 30 Jul 2019 22:27:22 +0000 (22:27 +0000)]
Use protobuf version to enable/disable mvt/geobuf
Closes #4419

git-svn-id: http://svn.osgeo.org/postgis/trunk@17648 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoAdd test case and update test case for null-handling behaviour
Paul Ramsey [Mon, 29 Jul 2019 17:36:47 +0000 (17:36 +0000)]
Add test case and update test case for null-handling behaviour
References #4209

git-svn-id: http://svn.osgeo.org/postgis/trunk@17645 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoadd in -d transform into enhancements list, move bug fixes into a separate section...
Regina Obe [Mon, 29 Jul 2019 16:58:16 +0000 (16:58 +0000)]
add in -d transform into enhancements list, move bug fixes into a separate section from enhancements.
This is to make it easier to spot and drop bug fixes if they are backported to older versions of PostGIS (as they won't be new things in PostGIS 3.0)

git-svn-id: http://svn.osgeo.org/postgis/trunk@17644 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoMatch JSON pretty print param name to one used in pgsql
Paul Ramsey [Mon, 29 Jul 2019 16:33:57 +0000 (16:33 +0000)]
Match JSON pretty print param name to one used in pgsql

git-svn-id: http://svn.osgeo.org/postgis/trunk@17640 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoHandle NULL geometry values in pgsql2shp
Paul Ramsey [Mon, 29 Jul 2019 16:32:03 +0000 (16:32 +0000)]
Handle NULL geometry values in pgsql2shp
References #4209

git-svn-id: http://svn.osgeo.org/postgis/trunk@17639 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoFix undefined behaviour in _postgis_gserialized_stats
Raúl Marín Rodríguez [Mon, 29 Jul 2019 15:34:52 +0000 (15:34 +0000)]
Fix undefined behaviour in _postgis_gserialized_stats

Closes #4466

git-svn-id: http://svn.osgeo.org/postgis/trunk@17635 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoHave run_test include full shp2pgsql commandline on failure
Sandro Santilli [Mon, 29 Jul 2019 14:00:07 +0000 (14:00 +0000)]
Have run_test include full shp2pgsql commandline on failure

git-svn-id: http://svn.osgeo.org/postgis/trunk@17631 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoDo not free state->geo_col, and do not strdup when assigning defaults
Sandro Santilli [Mon, 29 Jul 2019 14:00:00 +0000 (14:00 +0000)]
Do not free state->geo_col, and do not strdup when assigning defaults

git-svn-id: http://svn.osgeo.org/postgis/trunk@17630 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoFix memory leaks in shp2pgsql
Sandro Santilli [Mon, 29 Jul 2019 13:59:52 +0000 (13:59 +0000)]
Fix memory leaks in shp2pgsql

git-svn-id: http://svn.osgeo.org/postgis/trunk@17629 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoRemove unused variable from loader state
Sandro Santilli [Mon, 29 Jul 2019 13:35:43 +0000 (13:35 +0000)]
Remove unused variable from loader state

git-svn-id: http://svn.osgeo.org/postgis/trunk@17628 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoUse a single variable for column names
Sandro Santilli [Mon, 29 Jul 2019 13:28:21 +0000 (13:28 +0000)]
Use a single variable for column names

git-svn-id: http://svn.osgeo.org/postgis/trunk@17627 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoMissed a spot - get rid of hard-coding of 4326 for geography srid
Regina Obe [Mon, 29 Jul 2019 02:01:37 +0000 (02:01 +0000)]
Missed a spot - get rid of hard-coding of 4326 for geography srid
References #4466

git-svn-id: http://svn.osgeo.org/postgis/trunk@17626 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoTake out restriction that geography can only work with srid 4326
Regina Obe [Mon, 29 Jul 2019 01:47:16 +0000 (01:47 +0000)]
Take out restriction that geography can only work with srid 4326
Geography supports any long-lat projection since 2.2
Closes #4465

git-svn-id: http://svn.osgeo.org/postgis/trunk@17625 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoAdd regression tests for using -s from_srid:to_srid with -D (copy mode) for both...
Regina Obe [Mon, 29 Jul 2019 01:11:07 +0000 (01:11 +0000)]
Add regression tests for using -s from_srid:to_srid with -D (copy mode) for both geometry and geography
Closes #4403

git-svn-id: http://svn.osgeo.org/postgis/trunk@17624 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoHoepfully last trailing space
Regina Obe [Sun, 28 Jul 2019 21:37:00 +0000 (21:37 +0000)]
Hoepfully last trailing space
References #4403

git-svn-id: http://svn.osgeo.org/postgis/trunk@17623 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoGet rid of trailing spaces
Regina Obe [Sun, 28 Jul 2019 21:27:20 +0000 (21:27 +0000)]
Get rid of trailing spaces
References #4403

git-svn-id: http://svn.osgeo.org/postgis/trunk@17622 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoSupport for srid reprojection when using -D switch
Regina Obe [Sun, 28 Jul 2019 21:14:48 +0000 (21:14 +0000)]
Support for srid reprojection when using -D switch
References #4403
Tests forthcoming

git-svn-id: http://svn.osgeo.org/postgis/trunk@17621 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agopostgis_extensions_upgrade() also updates after pg_upgrade
Raúl Marín Rodríguez [Mon, 22 Jul 2019 13:27:46 +0000 (13:27 +0000)]
postgis_extensions_upgrade() also updates after pg_upgrade

Closes #4271
Closes https://github.com/postgis/postgis/pull/449

git-svn-id: http://svn.osgeo.org/postgis/trunk@17620 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoDisable tests that give different answer on Proj.5 vs. Proj.4
Raúl Marín Rodríguez [Mon, 22 Jul 2019 11:35:56 +0000 (11:35 +0000)]
Disable tests that give different answer on Proj.5 vs. Proj.4

References #4104

git-svn-id: http://svn.osgeo.org/postgis/trunk@17619 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoTopology: Remove TODOs
Raúl Marín Rodríguez [Fri, 19 Jul 2019 14:49:17 +0000 (14:49 +0000)]
Topology: Remove TODOs

git-svn-id: http://svn.osgeo.org/postgis/trunk@17618 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agolwcompound_stroke: Remove unused function
Raúl Marín Rodríguez [Fri, 19 Jul 2019 14:21:01 +0000 (14:21 +0000)]
lwcompound_stroke: Remove unused function

git-svn-id: http://svn.osgeo.org/postgis/trunk@17617 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoRe-enable gdal tests
Raúl Marín Rodríguez [Fri, 19 Jul 2019 13:02:56 +0000 (13:02 +0000)]
Re-enable gdal tests

Reverts r16688

Closes #4104
Closes https://github.com/postgis/postgis/pull/450

git-svn-id: http://svn.osgeo.org/postgis/trunk@17616 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoDealing with IGN SRIDs from Michel Philippenko
Regina Obe [Fri, 19 Jul 2019 05:47:19 +0000 (05:47 +0000)]
Dealing with IGN SRIDs from Michel Philippenko
closes https://github.com/postgis/postgis/pull/448
for PostGIS 23.0

git-svn-id: http://svn.osgeo.org/postgis/trunk@17615 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoCorrect description of ST_BandPixelType function
Regina Obe [Thu, 18 Jul 2019 16:29:59 +0000 (16:29 +0000)]
Correct description of ST_BandPixelType function
Closes https://github.com/postgis/postgis/pull/447
thanks Mateusz Łoskot

git-svn-id: http://svn.osgeo.org/postgis/trunk@17613 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoMake berrie script a bit more generic and add regular make check as well
Regina Obe [Tue, 16 Jul 2019 21:42:00 +0000 (21:42 +0000)]
Make berrie script a bit more generic and add regular make check as well

git-svn-id: http://svn.osgeo.org/postgis/trunk@17612 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoChange to test again PG 12 (instead of 13)
Regina Obe [Tue, 16 Jul 2019 15:28:56 +0000 (15:28 +0000)]
Change to test again PG 12 (instead of 13)
Closes #4456

git-svn-id: http://svn.osgeo.org/postgis/trunk@17611 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoRevise berrie to use her own custom PostgreSQL build -- evidentally installing past...
Regina Obe [Tue, 16 Jul 2019 14:19:07 +0000 (14:19 +0000)]
Revise berrie to use her own custom PostgreSQL build -- evidentally installing past the jenkins workspace is a no no for some reason

git-svn-id: http://svn.osgeo.org/postgis/trunk@17610 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoAdd CPPFLAGS where missing
Raúl Marín Rodríguez [Tue, 16 Jul 2019 08:58:59 +0000 (08:58 +0000)]
Add CPPFLAGS where missing

Spotted by Debian's build log hardening checker, blhc.

https://salsa.debian.org/debian-gis-team/postgis/-/jobs/222378

Patch by Christoph Berg <myon -at- debian.org>

Closes https://github.com/postgis/postgis/pull/446

git-svn-id: http://svn.osgeo.org/postgis/trunk@17609 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoTry to get berrie to use workspace installed pg12 to get around make install installi...
Regina Obe [Mon, 15 Jul 2019 23:14:22 +0000 (23:14 +0000)]
Try to get berrie to use workspace installed pg12 to get around make install installing in wrong folder
References #4456

git-svn-id: http://svn.osgeo.org/postgis/trunk@17605 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoStop trying to run createlang -- plpgsql is always installed
Regina Obe [Mon, 15 Jul 2019 12:38:43 +0000 (12:38 +0000)]
Stop trying to run createlang -- plpgsql is always installed
Closes #4457

git-svn-id: http://svn.osgeo.org/postgis/trunk@17604 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoST_IsEmpty: Speed up by avoiding deserialization
Raúl Marín Rodríguez [Mon, 15 Jul 2019 10:13:23 +0000 (10:13 +0000)]
ST_IsEmpty: Speed up by avoiding deserialization

Closes #4453
Closes https://github.com/postgis/postgis/pull/442

git-svn-id: http://svn.osgeo.org/postgis/trunk@17603 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoST_Startpoint: Improve tests and documentation
Raúl Marín Rodríguez [Mon, 15 Jul 2019 10:08:13 +0000 (10:08 +0000)]
ST_Startpoint: Improve tests and documentation

Closes https://github.com/postgis/postgis/pull/443/

git-svn-id: http://svn.osgeo.org/postgis/trunk@17602 b70326c6-7e19-0410-871a-916f4a2858ee

5 years ago_ST_OrderingEquals: Avoid deserialization
Raúl Marín Rodríguez [Mon, 15 Jul 2019 10:07:03 +0000 (10:07 +0000)]
_ST_OrderingEquals: Avoid deserialization

Closes #4454
Closes https://github.com/postgis/postgis/pull/444

git-svn-id: http://svn.osgeo.org/postgis/trunk@17601 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoFast Hilbert btree.
Darafei Praliaskouski [Sun, 14 Jul 2019 14:24:18 +0000 (14:24 +0000)]
Fast Hilbert btree.

Requires btree indexes to be recreated.

Closes https://github.com/postgis/postgis/pull/436
Closes #3883

git-svn-id: http://svn.osgeo.org/postgis/trunk@17600 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agorevise to install and test extensions
Regina Obe [Sun, 14 Jul 2019 05:06:19 +0000 (05:06 +0000)]
revise to install and test extensions

git-svn-id: http://svn.osgeo.org/postgis/trunk@17599 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoJust let postgis build put wherever it wants the tmp files
Regina Obe [Sun, 14 Jul 2019 04:43:36 +0000 (04:43 +0000)]
Just let postgis build put wherever it wants the tmp files

git-svn-id: http://svn.osgeo.org/postgis/trunk@17598 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agorevise to have tmp folder in code folder to try to get around issue can't create...
Regina Obe [Sun, 14 Jul 2019 04:15:41 +0000 (04:15 +0000)]
revise to have tmp folder in code folder to try to get around issue can't create directory

git-svn-id: http://svn.osgeo.org/postgis/trunk@17597 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoFix Berrie's badge link. Add badge links for Bessie and Bessie32. revise to 3 bots...
Regina Obe [Sun, 14 Jul 2019 02:57:13 +0000 (02:57 +0000)]
Fix Berrie's badge link.  Add badge links for Bessie and Bessie32. revise to 3 bots per line

git-svn-id: http://svn.osgeo.org/postgis/trunk@17596 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoAdd berrie to list of buildbots. revise berrie script to create ~tmp folder if it...
Regina Obe [Sun, 14 Jul 2019 02:41:23 +0000 (02:41 +0000)]
Add berrie to list of buildbots.  revise berrie script to create ~tmp folder if it doesn't exist
References #4456

git-svn-id: http://svn.osgeo.org/postgis/trunk@17595 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoAdd berrie's ci script
Regina Obe [Sun, 14 Jul 2019 01:14:43 +0000 (01:14 +0000)]
Add berrie's ci script
berrie is a Rasberry Pi 32-bit system running Debian Buster (10), graciously offered by Bruce Rindahl

References #4456

git-svn-id: http://svn.osgeo.org/postgis/trunk@17594 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoSpeed up ST_X, ST_Y, ST_Z and ST_M
Raúl Marín Rodríguez [Fri, 12 Jul 2019 16:03:58 +0000 (16:03 +0000)]
Speed up ST_X, ST_Y, ST_Z and ST_M

Closes https://github.com/postgis/postgis/pull/435
Closes https://trac.osgeo.org/postgis/ticket/4449

git-svn-id: http://svn.osgeo.org/postgis/trunk@17593 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoAdd new entries to spatial_ref_sys and handle non-EPSG authnames
Paul Ramsey [Fri, 12 Jul 2019 16:00:06 +0000 (16:00 +0000)]
Add new entries to spatial_ref_sys and handle non-EPSG authnames
Closes #4417

git-svn-id: http://svn.osgeo.org/postgis/trunk@17592 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agogserialized: Style changes
Raúl Marín Rodríguez [Fri, 12 Jul 2019 15:57:14 +0000 (15:57 +0000)]
gserialized: Style changes

References #4449

git-svn-id: http://svn.osgeo.org/postgis/trunk@17591 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoFix Makefile override warning
Sandro Santilli [Wed, 10 Jul 2019 22:49:56 +0000 (22:49 +0000)]
Fix Makefile override warning

Fixes the following:

  warning: overriding recipe for target 'check'
  .../pgxs.mk:276: warning: ignoring old recipe for target 'check'

git-svn-id: http://svn.osgeo.org/postgis/trunk@17590 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoDon't leave .bak files in staged install
Sandro Santilli [Wed, 10 Jul 2019 22:49:50 +0000 (22:49 +0000)]
Don't leave .bak files in staged install

git-svn-id: http://svn.osgeo.org/postgis/trunk@17589 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoAdd example using optional bounds
Paul Ramsey [Wed, 10 Jul 2019 21:34:40 +0000 (21:34 +0000)]
Add example using optional bounds

git-svn-id: http://svn.osgeo.org/postgis/trunk@17588 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoAdd ST_TileEnvelope utility function
Paul Ramsey [Wed, 10 Jul 2019 20:44:52 +0000 (20:44 +0000)]
Add ST_TileEnvelope utility function
Closes #4452

git-svn-id: http://svn.osgeo.org/postgis/trunk@17587 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoSpeed up ST_GeometryType
Raúl Marín Rodríguez [Tue, 9 Jul 2019 15:43:19 +0000 (15:43 +0000)]
Speed up ST_GeometryType

Closes https://github.com/postgis/postgis/pull/434
Closes #4450

git-svn-id: http://svn.osgeo.org/postgis/trunk@17586 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoFix the calculation of gserialized_max_header_size
Raúl Marín Rodríguez [Tue, 9 Jul 2019 15:33:24 +0000 (15:33 +0000)]
Fix the calculation of gserialized_max_header_size

Closes #4451
Closes https://github.com/postgis/postgis/pull/433

git-svn-id: http://svn.osgeo.org/postgis/trunk@17585 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoAddress compiler warning in 32b systems
Raúl Marín Rodríguez [Tue, 9 Jul 2019 15:30:01 +0000 (15:30 +0000)]
Address compiler warning in 32b systems

git-svn-id: http://svn.osgeo.org/postgis/trunk@17584 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoIgnore TiledAutoSkipNoData.tif
Paul Ramsey [Mon, 8 Jul 2019 21:08:55 +0000 (21:08 +0000)]
Ignore TiledAutoSkipNoData.tif

git-svn-id: http://svn.osgeo.org/postgis/trunk@17583 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoStrip out getMachineEndian() in favour of configure-time check
Paul Ramsey [Tue, 2 Jul 2019 19:47:06 +0000 (19:47 +0000)]
Strip out getMachineEndian() in favour of configure-time check

git-svn-id: http://svn.osgeo.org/postgis/trunk@17582 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoFix bug in lwgeom_le
Raúl Marín Rodríguez [Tue, 2 Jul 2019 09:00:54 +0000 (09:00 +0000)]
Fix bug in lwgeom_le

Closes #4445

git-svn-id: http://svn.osgeo.org/postgis/trunk@17580 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoImprove hash changes NEWS
Raúl Marín Rodríguez [Tue, 2 Jul 2019 08:44:46 +0000 (08:44 +0000)]
Improve hash changes NEWS

Since the output of the function has changed, any
index using it must be reindexed

References #4433

git-svn-id: http://svn.osgeo.org/postgis/trunk@17577 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoget rid of -e in packaging (causing error to be thrown if tries to remove zip not...
Regina Obe [Mon, 1 Jul 2019 19:01:42 +0000 (19:01 +0000)]
get rid of -e in packaging (causing error to be thrown if tries to remove zip not present), minor adjustments to packaging.

git-svn-id: http://svn.osgeo.org/postgis/trunk@17576 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agofix for 32-bit hash
Regina Obe [Mon, 1 Jul 2019 18:15:25 +0000 (18:15 +0000)]
fix for 32-bit hash
Closes #4433
Closes https://github.com/postgis/postgis/pull/429

git-svn-id: http://svn.osgeo.org/postgis/trunk@17575 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoFlip to 3.0.0alpha4dev
Regina Obe [Mon, 1 Jul 2019 14:03:24 +0000 (14:03 +0000)]
Flip to 3.0.0alpha4dev

git-svn-id: http://svn.osgeo.org/postgis/trunk@17574 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoPrep for 3.0.0alpha3 release
Regina Obe [Mon, 1 Jul 2019 07:31:51 +0000 (07:31 +0000)]
Prep for 3.0.0alpha3 release

git-svn-id: http://svn.osgeo.org/postgis/trunk@17572 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agooptional cgal version
Regina Obe [Mon, 1 Jul 2019 03:37:02 +0000 (03:37 +0000)]
optional cgal version

git-svn-id: http://svn.osgeo.org/postgis/trunk@17571 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agomore changes to allow custom building of version items
Regina Obe [Mon, 1 Jul 2019 01:27:27 +0000 (01:27 +0000)]
more changes to allow custom building of version items

git-svn-id: http://svn.osgeo.org/postgis/trunk@17570 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoType lookups in FDW fail due to sparse search_path.
Paul Ramsey [Fri, 28 Jun 2019 16:49:59 +0000 (16:49 +0000)]
Type lookups in FDW fail due to sparse search_path.
References #4440

git-svn-id: http://svn.osgeo.org/postgis/trunk@17567 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoFix wagyu configure dropping CPPFLAGS
Raúl Marín Rodríguez [Fri, 28 Jun 2019 15:39:05 +0000 (15:39 +0000)]
Fix wagyu configure dropping CPPFLAGS

Closes #4443

git-svn-id: http://svn.osgeo.org/postgis/trunk@17566 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoRewrite GiST penalty.
Darafei Praliaskouski [Fri, 28 Jun 2019 10:00:18 +0000 (10:00 +0000)]
Rewrite GiST penalty.

Use value of 0 as often as possible, as it's special code path in Postgres.
Fix picksplit to use correct penalty function.
Drop dead code.

Closes #4441
Closes https://github.com/postgis/postgis/pull/425

git-svn-id: http://svn.osgeo.org/postgis/trunk@17565 b70326c6-7e19-0410-871a-916f4a2858ee

5 years ago[raster] Skip NODATA tiles in raster2pgsql.
Darafei Praliaskouski [Fri, 28 Jun 2019 09:42:49 +0000 (09:42 +0000)]
[raster] Skip NODATA tiles in raster2pgsql.

Closes #4442
Closes https://github.com/postgis/postgis/pull/427

git-svn-id: http://svn.osgeo.org/postgis/trunk@17564 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoadd more pkgconfig and make zlib swappable
Regina Obe [Thu, 27 Jun 2019 20:15:29 +0000 (20:15 +0000)]
add more pkgconfig and make zlib swappable

git-svn-id: http://svn.osgeo.org/postgis/trunk@17563 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agofix typo in news
Regina Obe [Thu, 27 Jun 2019 14:15:38 +0000 (14:15 +0000)]
fix typo in news

git-svn-id: http://svn.osgeo.org/postgis/trunk@17562 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoCommit missing file into SVN
Paul Ramsey [Thu, 27 Jun 2019 01:52:33 +0000 (01:52 +0000)]
Commit missing file into SVN

git-svn-id: http://svn.osgeo.org/postgis/trunk@17561 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoAdd extended flags area in serialization
Paul Ramsey [Wed, 26 Jun 2019 22:34:24 +0000 (22:34 +0000)]
Add extended flags area in serialization
Closes #4438

git-svn-id: http://svn.osgeo.org/postgis/trunk@17560 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoImprove output of lwgeom_summary
Sandro Santilli [Wed, 26 Jun 2019 08:04:14 +0000 (08:04 +0000)]
Improve output of lwgeom_summary

- Do not print a useless newline
- Use plural/singular correctly
- Prepend a colon to elements listing

git-svn-id: http://svn.osgeo.org/postgis/trunk@17559 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoAllow FULL OUTER JOIN on geometry.
Darafei Praliaskouski [Sat, 22 Jun 2019 20:08:40 +0000 (20:08 +0000)]
Allow FULL OUTER JOIN on geometry.

Closes #4394
Closes https://github.com/postgis/postgis/pull/409

git-svn-id: http://svn.osgeo.org/postgis/trunk@17557 b70326c6-7e19-0410-871a-916f4a2858ee

5 years ago[travis] Lint Python code for syntax errors
Darafei Praliaskouski [Sat, 22 Jun 2019 20:05:00 +0000 (20:05 +0000)]
[travis] Lint Python code for syntax errors

Patch by Christian Clauss

Closes #411

git-svn-id: http://svn.osgeo.org/postgis/trunk@17556 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoAddress GCC 9 warning
Raúl Marín Rodríguez [Fri, 21 Jun 2019 13:45:04 +0000 (13:45 +0000)]
Address GCC 9 warning

shpopen.c:1757:22: error: ‘. Probably broken SHP file’ directive
output may be truncated writing 26 bytes into a region of size
between 25 and 48 [-Werror=format-truncation=]

git-svn-id: http://svn.osgeo.org/postgis/trunk@17555 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoUse GEOSPrepare also for Points and Multipoints
Raúl Marín Rodríguez [Fri, 21 Jun 2019 10:49:32 +0000 (10:49 +0000)]
Use GEOSPrepare also for Points and Multipoints

This was removed waiting for a fix that was introduced
in GEOS 3.6, which is now the minimum required version.

Basic tests show this makes ST_Intersects with cached
points 30x faster.

Closes #3437

git-svn-id: http://svn.osgeo.org/postgis/trunk@17554 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoTravis: Avoid failing both if codecov download or upload fail
Raúl Marín Rodríguez [Thu, 20 Jun 2019 16:28:41 +0000 (16:28 +0000)]
Travis: Avoid failing both if codecov download or upload fail

git-svn-id: http://svn.osgeo.org/postgis/trunk@17553 b70326c6-7e19-0410-871a-916f4a2858ee

5 years ago[drone] Fix yml syntax (pull image)
Sandro Santilli [Thu, 20 Jun 2019 07:38:57 +0000 (07:38 +0000)]
[drone] Fix yml syntax (pull image)

git-svn-id: http://svn.osgeo.org/postgis/trunk@17551 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoRevert r17538
Raúl Marín Rodríguez [Wed, 19 Jun 2019 16:57:22 +0000 (16:57 +0000)]
Revert r17538

Some of the bots didn't like it

git-svn-id: http://svn.osgeo.org/postgis/trunk@17549 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoPROJ cache: Improve the eviction process
Raúl Marín Rodríguez [Wed, 19 Jun 2019 15:26:37 +0000 (15:26 +0000)]
PROJ cache: Improve the eviction process

Instead of selecting a projection that doesn't match
the input source srid and silently drop all cache elements
after it (potentially dropping the whole cache), we keep
a count to know how many item each element has been used
and only drop the element with less uses.

Closes #4372

git-svn-id: http://svn.osgeo.org/postgis/trunk@17548 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoPROJ: Remove the extra MemoryContext for PG9.6+
Raúl Marín Rodríguez [Wed, 19 Jun 2019 15:23:33 +0000 (15:23 +0000)]
PROJ: Remove the extra MemoryContext for PG9.6+

In PG9.6+ we can allocate callbacks in the parent node
and associate them directly without creating new contextes

References #4372

git-svn-id: http://svn.osgeo.org/postgis/trunk@17547 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoPROJ: Remove manual call to proj_context_set_search_paths
Raúl Marín Rodríguez [Wed, 19 Jun 2019 15:21:29 +0000 (15:21 +0000)]
PROJ: Remove manual call to proj_context_set_search_paths

AFAIK, we don't provide PROJ files inside our postgis installation
anymore and this is conflicting with PROJ6, as changing the
search path makes it unable to find the proj.db in the
default PATH.

git-svn-id: http://svn.osgeo.org/postgis/trunk@17546 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoPROJ6: Use proj_trans for single points
Raúl Marín Rodríguez [Wed, 19 Jun 2019 15:19:31 +0000 (15:19 +0000)]
PROJ6: Use proj_trans for single points

It's slighly faster to use it for single points,
and improves it to match PROJ5 performance

References #4372

git-svn-id: http://svn.osgeo.org/postgis/trunk@17545 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoPROJ: Use the cache memory context
Raúl Marín Rodríguez [Wed, 19 Jun 2019 15:17:19 +0000 (15:17 +0000)]
PROJ: Use the cache memory context

Before it was using malloc/free manually, so with
this change we depend fully on Postgres allocator

References #4372

git-svn-id: http://svn.osgeo.org/postgis/trunk@17544 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoPROJ: Avoid double lookups
Raúl Marín Rodríguez [Wed, 19 Jun 2019 15:16:15 +0000 (15:16 +0000)]
PROJ: Avoid double lookups

References #4372

git-svn-id: http://svn.osgeo.org/postgis/trunk@17543 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoIncrease size of internal PROJ cache
Raúl Marín Rodríguez [Wed, 19 Jun 2019 15:15:34 +0000 (15:15 +0000)]
Increase size of internal PROJ cache

Creating PROJ projections is specially slow for PROJ6, so
we want to avoid recalculating them as much as possible

This is specially important for ST_Buffer(geography) since
it decides the SRID, and thus the projection, dinamically
based on the geometry position around the globe.

References #4372

git-svn-id: http://svn.osgeo.org/postgis/trunk@17542 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoPROJ6: Speed improvements
Raúl Marín Rodríguez [Wed, 19 Jun 2019 15:12:21 +0000 (15:12 +0000)]
PROJ6: Speed improvements

Caches more elements to avoid recalculation per row

References #4372

git-svn-id: http://svn.osgeo.org/postgis/trunk@17541 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoFix NEWS related to 3.0alpha3
Raúl Marín Rodríguez [Wed, 19 Jun 2019 15:09:25 +0000 (15:09 +0000)]
Fix NEWS related to 3.0alpha3

git-svn-id: http://svn.osgeo.org/postgis/trunk@17540 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agolwgeom_transform_from_str: Avoid leaking resources under PROJ6+
Raúl Marín Rodríguez [Wed, 19 Jun 2019 15:07:49 +0000 (15:07 +0000)]
lwgeom_transform_from_str: Avoid leaking resources under PROJ6+

Closes #4429

git-svn-id: http://svn.osgeo.org/postgis/trunk@17539 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoConfigure: Avoid unnecessary errors with PROJ6
Raúl Marín Rodríguez [Wed, 19 Jun 2019 15:02:57 +0000 (15:02 +0000)]
Configure: Avoid unnecessary errors with PROJ6

No point on checking proj_api.h for PROJ6, just check
for proj.h directly

Related to #4372

git-svn-id: http://svn.osgeo.org/postgis/trunk@17538 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoBytebuffer: Ifdef unused code
Raúl Marín Rodríguez [Wed, 19 Jun 2019 11:57:19 +0000 (11:57 +0000)]
Bytebuffer: Ifdef unused code

Raises the coverage of the file
I was going to delete it, but convinced otherwise

git-svn-id: http://svn.osgeo.org/postgis/trunk@17537 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoTravis: Do not fail if the coverage upload fails
Raúl Marín Rodríguez [Tue, 18 Jun 2019 15:33:32 +0000 (15:33 +0000)]
Travis: Do not fail if the coverage upload fails

In a previous commit I'd only fixed run_coverage

git-svn-id: http://svn.osgeo.org/postgis/trunk@17536 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoFix error in bash preventing building
Regina Obe [Fri, 14 Jun 2019 22:52:39 +0000 (22:52 +0000)]
Fix error in bash preventing building

git-svn-id: http://svn.osgeo.org/postgis/trunk@17535 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoRespect geodetics when expanding a gbox
Paul Ramsey [Fri, 14 Jun 2019 17:47:07 +0000 (17:47 +0000)]
Respect geodetics when expanding a gbox

git-svn-id: http://svn.osgeo.org/postgis/trunk@17534 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoChange handling of index search tolerance, it's already in a prior function
Paul Ramsey [Fri, 14 Jun 2019 16:49:54 +0000 (16:49 +0000)]
Change handling of index search tolerance, it's already in a prior function

git-svn-id: http://svn.osgeo.org/postgis/trunk@17533 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoRefactor decode_geohash_bbox
Raúl Marín Rodríguez [Fri, 14 Jun 2019 08:55:37 +0000 (08:55 +0000)]
Refactor decode_geohash_bbox

Applied suggestion by Michael Entin and some extra cleanup

git-svn-id: http://svn.osgeo.org/postgis/trunk@17532 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoset defaults back to old and put projdir back in configure for some reason not pickin...
Regina Obe [Thu, 13 Jun 2019 23:54:32 +0000 (23:54 +0000)]
set defaults back to old and put projdir back in configure for some reason not picking up proj

git-svn-id: http://svn.osgeo.org/postgis/trunk@17531 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agolookup3: Address GCC warnings
Raúl Marín Rodríguez [Thu, 13 Jun 2019 14:54:46 +0000 (14:54 +0000)]
lookup3: Address GCC warnings

git-svn-id: http://svn.osgeo.org/postgis/trunk@17530 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoThrow on invalid characters when decoding geohash
Raúl Marín Rodríguez [Thu, 13 Jun 2019 11:57:13 +0000 (11:57 +0000)]
Throw on invalid characters when decoding geohash

Closes #4406
Closes https://github.com/postgis/postgis/pull/420

git-svn-id: http://svn.osgeo.org/postgis/trunk@17529 b70326c6-7e19-0410-871a-916f4a2858ee

5 years agoAvoid pfree'ing the result of getenv
Raúl Marín Rodríguez [Thu, 13 Jun 2019 07:42:31 +0000 (07:42 +0000)]
Avoid pfree'ing the result of getenv

References #4327
Closes https://github.com/postgis/postgis/pull/419/

git-svn-id: http://svn.osgeo.org/postgis/trunk@17522 b70326c6-7e19-0410-871a-916f4a2858ee