<div dir="ltr"><div class="gmail_default" style="font-family:monospace,monospace">Hey,<br></div><div class="gmail_default" style="font-family:monospace,monospace">I often wondered if pgpointcloud would work with postgresXL.<br></div><div class="gmail_default" style="font-family:monospace,monospace"><br></div><div class="gmail_default" style="font-family:monospace,monospace">I don't have any knwoledge of postgresxl,<br></div><div class="gmail_default" style="font-family:monospace,monospace">but I would be very gratefull if you could keep us posted!<br><br></div><div class="gmail_default" style="font-family:monospace,monospace">Cheers,<br></div><div class="gmail_default" style="font-family:monospace,monospace">Rémi-C<br></div></div><div class="gmail_extra"><br><div class="gmail_quote">2016-05-30 11:49 GMT+02:00 Jo Walsh <span dir="ltr"><<a href="mailto:metazool@gmail.com" target="_blank">metazool@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><pre style="margin-top:0px;margin-bottom:0px;padding:15px;border-width:0px 0px 0px 1px;border-left-style:solid;border-left-color:rgb(229,229,229);outline:0px;vertical-align:baseline;word-wrap:break-word;overflow:auto;background-image:initial;background-repeat:initial"><font face="monospace, sans-serif" color="#555555"><span style="font-size:13px;line-height:18px;white-space:pre-wrap">I wonder if anyone has tried out and had success with the PG Point Cloud
extension with Postgres-XL, the clustering version of Postgres? I am running through the basic
exercises and see it all almost, but not quite, working. I tried the Postgres-XL general list without any luck in response, so thought it worth re-posting here to see if it's something people have given thought to.</span></font></pre><pre style="margin-top:0px;margin-bottom:0px;padding:15px;border-width:0px 0px 0px 1px;border-left-style:solid;border-left-color:rgb(229,229,229);outline:0px;vertical-align:baseline;word-wrap:break-word;overflow:auto;background-image:initial;background-repeat:initial"><span style="font-size:13px;line-height:18px;white-space:pre-wrap;color:rgb(85,85,85);font-family:monospace,sans-serif"><a href="http://www.postgres-xl.org/overview/" target="_blank">http://www.postgres-xl.org/overview/</a></span></pre><pre style="margin-top:0px;margin-bottom:0px;padding:15px;border-width:0px 0px 0px 1px;border-left-style:solid;border-left-color:rgb(229,229,229);outline:0px;vertical-align:baseline;word-wrap:break-word;overflow:auto;background-image:initial;background-repeat:initial"><font face="monospace, sans-serif" color="#555555"><span style="font-size:13px;line-height:18px;white-space:pre-wrap">I am able to CREATE EXTENSION pointcloud on a Postgres-XL coordinator node
just as straightforwardly as with PostGIS, which works well. </span></font></pre><pre style="margin-top:0px;margin-bottom:0px;padding:15px;border-width:0px 0px 0px 1px;border-left-style:solid;border-left-color:rgb(229,229,229);outline:0px;vertical-align:baseline;word-wrap:break-word;overflow:auto;background-image:initial;background-repeat:initial"><font face="monospace, sans-serif" color="#555555"><span style="font-size:13px;line-height:18px;white-space:pre-wrap">However, the pgpointcloud creates a table pointcloud_formats which does not appear to be getting distributed.
The table looks like this:

testdb=# \d++ pointcloud_formats;
                  Table "public.pointcloud_formats"
 Column |  Type   | Modifiers | Storage  | Stats target | Description
--------+---------+-----------+----------+--------------+-------------
 pcid   | integer | not null  | plain    |              |
 srid   | integer |           | plain    |              |
 schema | text    |           | extended |              |
Indexes:
    "pointcloud_formats_pkey" PRIMARY KEY, btree (pcid)
Check constraints:
    "pointcloud_formats_pcid_check" CHECK (pcid > 0 AND pcid < 65536)
    "pointcloud_formats_schema_check" CHECK (pc_schemaisvalid(schema))

When I INSERT into it, data does not end up stored in the datanodes, and
when I subsequently try to INSERT into the points table,

ERROR:  no entry in "pointcloud_formats" for pcid = 1

Despite the fact that on the coordinator node I can SELECT from
pointcloud_formats and see a row with pcid=1. </span></font></pre><pre style="margin-top:0px;margin-bottom:0px;padding:15px;border-width:0px 0px 0px 1px;border-left-style:solid;border-left-color:rgb(229,229,229);outline:0px;vertical-align:baseline;word-wrap:break-word;overflow:auto;background-image:initial;background-repeat:initial"><font face="monospace, sans-serif" color="#555555"><span style="font-size:13px;line-height:18px;white-space:pre-wrap">There's more context including log entries in my original post to the Postgres-XL list here:</span></font></pre><pre style="margin-top:0px;margin-bottom:0px;padding:15px;border-width:0px 0px 0px 1px;border-left-style:solid;border-left-color:rgb(229,229,229);outline:0px;vertical-align:baseline;word-wrap:break-word;overflow:auto;background-image:initial;background-repeat:initial"><span style="font-size:13px;line-height:18px;white-space:pre-wrap;color:rgb(85,85,85);font-family:monospace,sans-serif"><a href="https://sourceforge.net/p/postgres-xl/mailman/message/35119267/" target="_blank">https://sourceforge.net/p/postgres-xl/mailman/message/35119267/</a></span></pre><pre style="margin-top:0px;margin-bottom:0px;padding:15px;border-width:0px 0px 0px 1px;border-left-style:solid;border-left-color:rgb(229,229,229);outline:0px;vertical-align:baseline;word-wrap:break-word;overflow:auto;background-image:initial;background-repeat:initial"><font face="monospace, sans-serif" color="#555555"><span style="font-size:13px;line-height:18px;white-space:pre-wrap">I know this is a long shot but any illumination would be appreciated,</span></font></pre><pre style="margin-top:0px;margin-bottom:0px;padding:15px;border-width:0px 0px 0px 1px;border-left-style:solid;border-left-color:rgb(229,229,229);outline:0px;vertical-align:baseline;word-wrap:break-word;overflow:auto;background-image:initial;background-repeat:initial"><font face="monospace, sans-serif" color="#555555"><span style="font-size:13px;line-height:18px;white-space:pre-wrap">
Jo</span></font></pre><pre style="margin-top:0px;margin-bottom:0px;padding:15px;border-width:0px 0px 0px 1px;border-left-style:solid;border-left-color:rgb(229,229,229);outline:0px;vertical-align:baseline;word-wrap:break-word;overflow:auto;background-image:initial;background-repeat:initial"><font face="monospace, sans-serif" color="#555555"><span style="font-size:13px;line-height:18px;white-space:pre-wrap"><br></span></font></pre></div>
<br>_______________________________________________<br>
pgpointcloud mailing list<br>
<a href="mailto:pgpointcloud@lists.osgeo.org">pgpointcloud@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgpointcloud" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgpointcloud</a><br></blockquote></div><br></div>