[postgis-users] lspostgis.sql shows errors

[Maria Arias de Reyna]

El Martes 20 Enero 2009 11:20, Mark Cave-Ayland escribió:
> That's really strange; so then it looks as if the geometry_dump()
> function is trying to write to the pg_catalog schema which is totally
> wrong. How did you build your PostGIS installation, and what does the
> definition for the geometry_dump() function look like in lwpostgis.sql?

I was using a debian stable and installed postgresql 8.3 from a backport. Then 
I used the postgis extension available on the web at that time (1.3.3) and 
after installing it, it worked fine.

Now (I installed and tried it on november more or less) I try to create a new 
database and that error appears.

I have tried updating to the last postgresql 8.3 available for debian stable 
(on the backports) and installing then the postgis extension 1.3.5 as you 
said.Same error.

lwpostgis.sql->geometry_dump():

CREATE TYPE geometry_dump AS (path integer[], geom geometry);

-- Deprecation in 1.2.3
CREATE OR REPLACE FUNCTION Dump(geometry)
        RETURNS SETOF geometry_dump
        AS '$libdir/liblwgeom', 'LWGEOM_dump'
        LANGUAGE 'C' IMMUTABLE STRICT; -- WITH (isstrict,iscachable);

-- Availability: 1.2.2
CREATE OR REPLACE FUNCTION ST_Dump(geometry)
        RETURNS SETOF geometry_dump
        AS '$libdir/liblwgeom', 'LWGEOM_dump'
        LANGUAGE 'C' IMMUTABLE STRICT; -- WITH (isstrict,iscachable);

-- Deprecation in 1.2.3
CREATE OR REPLACE FUNCTION DumpRings(geometry)
        RETURNS SETOF geometry_dump
        AS '$libdir/liblwgeom', 'LWGEOM_dump_rings'
        LANGUAGE 'C' IMMUTABLE STRICT; -- WITH (isstrict,iscachable);

-- Availability: 1.2.2
CREATE OR REPLACE FUNCTION ST_DumpRings(geometry)
        RETURNS SETOF geometry_dump
        AS '$libdir/liblwgeom', 'LWGEOM_dump_rings'
        LANGUAGE 'C' IMMUTABLE STRICT; -- WITH (isstrict,iscachable);



-- 
María Arias de Reyna Domínguez
Emergya Consultoría