[postgis-users] Trunk version problem with st_dumppoint

Andrea Peri aperi2007 at gmail.com
Wed Aug 18 10:31:15 PDT 2010


Hi,
I'm having problems with some test with trunk version.

I'm try-ing to test the 2.0.0 trunk version on a RedHat 64 bit with postgres
8.4.4.

The version of postgis is this:

POSTGIS="2.0.0SVN" GEOS="3.3.0-CAPI-1.7.0" PROJ="Rel. 4.7.1, 23 September
2009" LIBXML="2.6.26" USE_STATS (procs from 2.0 r5705 need upgrade)

Try-ing this query from a file "query.txt":

INSERT INTO public._test_campionamento_mp (id,idrtt,geom) (
    select
        c.id,
        c.idrtt,
        st_union(c.geom)
    from (
        select
            a.id as id,
            a.idrtt as idrtt,
            (ST_DumpPoints(a.geom)).* as geom
        from
            public._test_campionamento as a
    ) as c
    group by
        c.id,
        c.idrtt
);

I see this error:

psql:query.txt:19: ERROR:  could not find function
"LWGEOM_numpoints_linestring"
in file "/usr/local/pgsql/lib/postgis-2.0.so"
CONTEXT:  SQL statement "SELECT ST_NumPoints( $1 )"
PL/pgSQL function "_st_dumppoints" line 67 at istruzione SQL
PL/pgSQL function "_st_dumppoints" line 24 at ciclo FOR su righe di SELECT
SQL function "st_dumppoints" statement 1

This query work perfectly on postgres 8.4.4. + postgis 1.5.1 on WinXP so I
don't understand what is missing ...



-- 
-----------------
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-----------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100818/27c9103a/attachment.html>


More information about the postgis-users mailing list