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-boun...@postgis.refractions.net [mailto:postgis-users-boun...@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@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. _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users