[postgis-users] index and quadtree

[Cedric BERNIER]

Hi all,

I'm comparing OracleSpatial and PostGIS, and I would like to know if PostGIS uses sort of
quadtree in addition of its R-Tree-over-GiST scheme.

If not, do you think than that kind of index (quadtree) will be implemented soon? Do you think
that PostGis users need it ?

Chris Hodgson a écrit :

> Is it possible that it is using an old library file, from when you perhaps had postgres
> 7.1 installed in the same directory? I would suggest this as a possibility because the
> ggeometry_consistent function is the first function defined in postgis.sql which changed
> in the library from 7.1 to 7.2. Check the date on the library file, and ensure that it is
> being copied correctly, and referenced correctly by the sql file.
>
> We have tested it on Solaris 6 on our SPARC  box, and it compiles, installs, and functions
> correctly, so it doesn't seem to be just a "Solaris bug".
>
> Chris
>
> Jonathan Lowe wrote:
>
> > Hello,
> >
> > An error is surfacing at the tail end of a PostGIS installation on a
> > Solaris 2.7 platform with PostgreSQL 7.2.1 and postgis 0.7.0.
> >
> > The following commands were successful:
> >       "make" (with the 72 switch set to "1")
> >       "make install" (with a perl script fix of some DOS carriage return
> > problems)
> >       "createlang plpgsql <yourdatabase>"
> >
> > However, the command "psql -f postgis.sql -d <yourdatabase>" results in the
> > following error:
> >
> > (...long list of various successful transactions...)
> > BEGIN
> > psql:postgis.sql:764: ERROR:  Can't find function ggeometry_consistent in
> > file /local3/pgsql/lib/contrib/libpostgis.so.0.7
> > BEGIN TRANSACTION;
> > (...remaining function creation statements within this BEGIN work block
> > aborted...)
> >
> > The path (/local3/pgsql/lib/contrib) and library file are correct and
> > exist.
> >
> > The statement in the postgis.sql file raising the error is the following:
> >
> > -------- 7.2 GiST support functions
> > create function ggeometry_consistent(opaque,GEOMETRY,int4) returns bool
> > as '/local3/pgsql/lib/contrib/libpostgis.so.0.7'   language 'C';
> >
> > Commenting out these lines and running the postgis.sql file again results
> > in a similar error for the next "create function" statement, which also
> > relies on the libpostgis.so.0.7 file.
> >
> > Other archived discussions refer to this lib file, but not in the context
> > of running postgis.sql.
> >
> > Any suggestions?
> >
> > Regards,
> >
> > Jonathan W. Lowe (jonathan at us.ibm.com)
> > Senior IT Specialist, IBM Data Management
> > --------------------------------------------------------------------------------------
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
-------------- next part --------------
A non-text attachment was scrubbed...
Name: cedric.bernier.vcf
Type: text/x-vcard
Size: 377 bytes
Desc: Carte pour Cedric BERNIER
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20020514/ad9b3bf7/attachment.vcf>