<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 color="#555555" face="monospace, sans-serif"><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/">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 color="#555555" face="monospace, sans-serif"><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 color="#555555" face="monospace, sans-serif"><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 color="#555555" face="monospace, sans-serif"><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/">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 color="#555555" face="monospace, sans-serif"><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 color="#555555" face="monospace, sans-serif"><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 color="#555555" face="monospace, sans-serif"><span style="font-size:13px;line-height:18px;white-space:pre-wrap"><br></span></font></pre></div>