[pgpointcloud] pointcloud version and variant

[Regina Obe]

Lars,

 

I've rebuilt the 9.5, 9.6, 10 64-bit builds with the latest head.  It should
have a pgpointcloud_version.txt 

 

With content - GIT_REVISION: HEAD detached at 0146bd7

 

 

Please use this one and you should have the function you are missing.

 

https://winnie.postgis.net/download/windows/pg95/buildbot/extras/pointcloud-
pg95-binaries-1.1.0devw64gcc48.zip

 

 

 

I didn't test though because I think the tests require liblas compression
included, which I haven't revised the builds to build with.  I'll reenable
the tests after I have the liblas compression in place.

 

I don't plan to build with libght since it was difficult to build the
library and Paul had told me a while ago (not sure if it's still true) that
libght didn't provide much of a performance improvement and was an
experimental format.

 

Eric,

 

If you want to go ahead and tag an official release for this, that would be
great especially since the currently released doesn't work past PostgreSQL
9.5.

 

Thanks,

Regina

 

 

From: Regina Obe [mailto:lr at pcorp.us] 
Sent: Wednesday, April 25, 2018 10:41 AM
To: 'Lars' <laasunde at hotmail.com>; 'pgpointcloud at lists.osgeo.org'
<pgpointcloud at lists.osgeo.org>
Subject: RE: [pgpointcloud] pointcloud version and variant

 

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 <mailto: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/21fdceef/attachment.html>