[postgis-devel] Regarding Sp-gist implementation in postgis

[mohit kumar]

Hi strk,
As my system crashed and I had to build everything again. Now Even I am
getting the same error.
test1=# create index on points using spgist(g);
The connection to the server was lost. Attempting reset: Failed.
!>

While using valgrind debuging the following error comes :
mohit at mohit-Inspiron-1545:~/builds/source/postgis$ echo "create index on
points using spgist(g);" | valgrind --leak-check=yes --log-file=valgrindlog
/usr/local/pgsql/bin/postgres -D /usr/local/pgdata --single postgis
FATAL:  --single requires a value

Also what is the "path/to/database" to be used for pg_ctl?

Regards,
Mohit
On Fri, Jul 18, 2014 at 1:24 PM, Sandro Santilli <strk at keybit.net> wrote:

> On Thu, Jul 17, 2014 at 10:20:17PM +0530, mohit kumar wrote:
>
> > I wantedly defined no operators for the opclass. Only functions.
>
> I understand sp-gist access method _requires_ defining operators to
> implement a set of strategies (numbers 1,5,6,8,10,11).
>
> Anyway, as the error talks about missing support function instead...
> I tried installing your version of PostGIS [1] and here's what I get:
>
> spgist=# create table t(g geometry);
> CREATE TABLE
> spgist=# create index on t using spgist(g);
> DEBUG:  building index "t_g_idx" on table "t"
> The connection to the server was lost. Attempting reset: Failed.
> !>
>
> Maybe the message you're getting is just misleading due to a memory
> bug triggering arbitrary pieces of code ?
>
> I suggest you add more debugging prints in your code, and also it may
> be useful to take a look at what you got so far with valgrind:
> http://blog.cleverelephant.ca/2008/08/valgrinding-postgis.html
>
> [1] https://github.com/mohitkharb/postgis/tree/spgist
>
> --strk;
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-devel
>



-- 
Mohit Kumar
+91-970-3840-175
Lab For Spatial Informatics
International Institute of Information Technology
Hyderabad, India
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20140723/132be865/attachment.html>