[pgpointcloud] pointcloud version and variant

[Regina Obe]

Okay I'll add that.  I had put it in the readme that neither is included yet but LAZPERF I will try to include.

 

Version number?  Where are you looking?

 

From: Lars [mailto:laasunde at hotmail.com] 
Sent: Thursday, April 26, 2018 2:56 AM
To: Regina Obe <lr at pcorp.us>; pgpointcloud at lists.osgeo.org
Cc: 'Éric Lemoine' <eric.lemoine at oslandia.com>
Subject: Sv: [pgpointcloud] pointcloud version and variant

 

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 <mailto:lr at pcorp.us> >
Sendt: 25. april 2018 21:12
Til: 'Lars'; pgpointcloud at lists.osgeo.org <mailto: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 <mailto:laasunde at hotmail.com> >; 'pgpointcloud at lists.osgeo.org' <pgpointcloud at lists.osgeo.org <mailto: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/689406bf/attachment-0001.html>