[postgis-devel] [SoC] "Gsoc weekly report 6": Implement sp-gist clustering in PostGIS and cartoDB
mohitkharb at gmail.com
Wed Jul 2 01:57:21 PDT 2014
Now make check is giving no errors. I used "box2df" in place of "geometry".
On Mon, Jun 30, 2014 at 3:06 PM, Sandro Santilli <strk at cartodb.com> wrote:
> On Mon, Jun 30, 2014 at 12:18:23AM +0530, mohit kumar wrote:
> > *What do I plan on doing next week?*
> > Work on building the storage type for access method "sp-gist"
> Mohit, the storage type you don't have to "build" it.
> All types are built, you only have to specify which
> type has to be used by the operatoc class.
> The problem you were having is that you tried to use
> a storage type of "box2df" while associating the opclass
> to the type "geometry". The error message told you this
> mixing of types is not supported by the "spgist" access
> method. So you just have to pick one type and use it for
> both storage type and target type.
> Picking "geometry" would make the index bigger.
> Picking anything else would make usage a bit convoluted as you
> would not be able to index a "geometry" column but you'd have
> to index the output of a function applied to it, returning the
> choosed type.
> I'd go with "box2df" for a start.
> () ASCII ribbon campaign -- Keep it simple !
> /\ http://strk.keybit.net/rants/ascii_mails.txt
Lab For Spatial Informatics
International Institute of Information Technology
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgis-devel