[pgpointcloud] pointcloud version and variant

[Lars]

Regina,

Thank you so much for your help.

I will update to newest extension 😊

If you are making a new official release maybe consider updating the version number which I believe has been fixed since 2015.

Just a minor request, would it be possible to include if GHT and/or LAZPERF is enabled in the pgpointcloud_version.txt?

kind regards Lars
________________________________
Fra: Regina Obe <lr at pcorp.us>
Sendt: 25. april 2018 21:12
Til: 'Lars'; pgpointcloud at lists.osgeo.org
Kopi: 'Éric Lemoine'
Emne: RE: [pgpointcloud] pointcloud version and variant


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/20180426/37babd43/attachment-0001.html>