[pgpointcloud] Columns and patch schema matching

[Paul Ramsey]

It should be the same schema, and should be found and the id re-used. That seems a simple test to run (import same file twice, schema should be re-used) , could you ticket it?


--  
http://postgis.net  
http://cleverelephant.ca


On December 26, 2013 at 9:26:38 AM, Roger Bedell (rbedell at coordinatesolutions.com) wrote:
>  
> Hello Paul and Howard,
>  
> I'm getting this error even if I import the same file twice, the  
> first time
> with overwrite=true, and second time with false.
> Shouldn't the schema be the same?
>  
> Roger
>  
>  
>  
>  
>  
>  
>  
> On Mon, Dec 16, 2013 at 6:18 PM, Paul Ramsey wrote:  
>  
> > Yes, that seems reasonable. You could also create the table  
> ahead of time
> > and run in append mode.
> > P.
> >
> > --
> > Paul Ramsey
> > http://cleverelephant.ca
> > http://postgis.net
> >
> > On December 16, 2013 at 8:24:47 AM, Howard Butler (howard at hobu.co)  
> > wrote:
> >
> > Should this typemod be on by default, or alternatively, should  
> we craft an
> > option to allow you to turn it off?
> >
> > On Dec 16, 2013, at 9:46 AM, Paul Ramsey  
> > wrote:
> >
> > > This error is the typmod guard complaining. You’ve defined  
> a table like
> > >
> > > CREATE TABLE patchs ( gid INTEGER PRIMARY KEY, pa PCPATCH(1)  
> );
> > >
> > > So your table is been referenced to PCID 1, in the pa column definition.  
> > > If you when try and insert a patch with PCID 2, it’ll complain.  
> > >
> > > You could define a column a PCPATCH without a PCID constraint,  
> if you
> > want to mix your PCIDs in one column. Or you could force a PCID,  
> if you’re
> > certain about the dimensionality of your inputs.
> > >
> > > P
> > >
> > >
> > > --
> > > http://postgis.net
> > > http://cleverelephant.ca
> > >
> > >
> > > On December 16, 2013 at 7:41:07 AM, Howard Butler (howard at hobu.co)  
> > wrote:
> > >>
> > >> I am loading a bunch of files, and one of the errors I frequently  
> > >> see but don't completely understand is the following:
> > >>
> > >>> Caught PDAL exception: ERROR: column pcid (1) and patch  
> pcid
> > >> (2) are not consistent
> > >>
> > >>
> > >> I take it this means that the schema of the patch I'm currently  
> > >> loading (from file B) doesn't currently match the schema  
> of the
> > >> column I'm inserting data into (created by file A, I suppose)?  
> > >> So the question becomes how do I harmonize my directory of  
> 35,000
> > >> files into a single schema that pgpointcloud can love? I see  
> the
> > >> writer has the ability to override the schema with a "pcid"  
> option,
> > >> but this points the danger at your toes.
> > >>
> > >> In PDAL, there is a filter called "filters.selector"[1]  
> which
> > >> has the ability to mark which dimensions in the pipeline's  
> schema
> > >> should be kept, ignored, or created. It should be the responsibility  
> > >> of the "drivers.pgpointcloud.writer" to make sure to pack()  
> > >> the schema and pack() the data it is writing to remove ignored  
> > >> dimensions. This is the only way I can think of to harmonize  
> the
> > >> layout of all 35,000 files into the same schema. To that end,  
> I
> > >> have added some code to PDAL to support this, and updated the  
> > pgpointcloud
> > >> writer to use it.
> > >>
> > >> In oracle's point cloud storage, each patch has a reference  
> to
> > >> its own schema rather than the entire table pointing at a single  
> > >> schema (often a bunch of patches pointing at the same one,  
> but
> > >> that's an implementation detail). This is difference that  
> should
> > >> be pointed out in documentation and examples more clearly.  
> I
> > >> will come up with an example that uses the selector filter  
> and
> > >> provide a pull request to incorporate it with detail on why  
> you
> > >> should care.
> > >>
> > >> Howard
> > >>
> > >> [1] http://www.pointcloud.org/stages/filters.selector.html  
> > >> _______________________________________________
> > >> pgpointcloud mailing list
> > >> pgpointcloud at lists.osgeo.org
> > >> http://lists.osgeo.org/cgi-bin/mailman/listinfo/pgpointcloud  
> > >>
> > >
> >
> > ------------------------------
> > - signature.asc, 506 bytes
> >
> >
> > _______________________________________________
> > pgpointcloud mailing list
> > pgpointcloud at lists.osgeo.org
> > http://lists.osgeo.org/cgi-bin/mailman/listinfo/pgpointcloud  
> >
>  
>  
>  
> --
> Roger Bedell
> Coordinate Solutions Inc.
>