[postgis-users] lspostgis.sql shows errors

[Obe, Regina]

Strange.  Is it the same error as you got before?

What does 

SELECT * FROM pg_settings WHERE name = 'search_path' 

return.

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Maria Arias de Reyna
Sent: Tuesday, January 20, 2009 6:27 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] lspostgis.sql shows errors

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
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.