[pgpointcloud] pointcloud version and variant

[Regina Obe]

Just a note, I'm running the PostgreSQL 10.3 windows build and I DO see a

 

pc_envelopegeometry(pcpatch)  function.

 

Also looking at the latest built, pointcloud for 9.5 which is here:

 

https://winnie.postgis.net/download/windows/pg95/buildbot/extras/

 

I do see a version.txt file, which does include the HASH info of the git
repo, the sql file.

I confirm does seem to be missing the PC_EnvelopeGeometry function.

 


POSTGIS POINTCLOUD: 1.1.0dev

		

PostgreSQL: 9.5 w64

				

Built: 20160607

				

GIT_REPO: https://github.com/pointcloud/pointcloud

	

GIT_BRANCH: origin/master

			

GIT_REVISION: 206bd54c459c53ef158e36389d80d25ba79e9183


 

Is there a reason you can't use the newer PostgreSQL 9.6 or 10? (though I
see for some reason though those are newer, the version.txt file was not
added so I'll revisit that)

 

Anyway when I build next I'll build newer for PostgreSQL 9.5 as well so will
have that function.

 

 

 

From: pgpointcloud [mailto:pgpointcloud-bounces at lists.osgeo.org] On Behalf
Of Lars
Sent: Wednesday, April 25, 2018 6:58 AM
To: pgpointcloud at lists.osgeo.org
Subject: [pgpointcloud] pointcloud version and variant

 

Hello,

 

Running Win7+SP1, PostgreSQL 9.5 and bundle95x64_2.3.0.1.

 

*  The following query produces "function pc_envelopegeometry does not
exist"

*  SELECT ST_AsText(PC_EnvelopeGeometry(pa)) FROM patches LIMIT 5;

 

The following query works are expected: 

SELECT PC_Intersects('SRID=4326;POINT(-126.451 45.552)'::geometry, pa) FROM
patches limit 5;

 

Why is PC_Intersects available but not PC_EnvelopGeometry when both are
listed in PointCloud documentation?

 

How can I determine if I am running latest version of pointcloud extension?

 

How can I determine if pointcloud is built with GHT and/or LAZPERF ?

 

*  Opening psql and running the following command;

\d po*

 

postgis 2.3.0

pointcloud 1.1.0

pointcloud_postgis 1.0

 

 

kind regards, Lars

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgpointcloud/attachments/20180425/b8989bbd/attachment-0001.html>