[postgis-users] lspostgis.sql shows errors

Obe, Regina robe.dnd at cityofboston.gov
Tue Jan 20 10:18:50 PST 2009


I don't quite understand your answer.  I meant what does it return.  I guess
this might be simpler.

SELECT setting FROM pg_settings WHERE name = 'search_path'

On my working databases this should return for setting


I was thinking that maybe for some reason on the database that is not working yours is returning

pg_catalog,"$user", public

or is not returning any answer
which would possibly explain why it is trying to
write to the pg_catalog database.

Hope that helps,

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net on behalf of Maria Arias de Reyna
Sent: Tue 1/20/2009 10:01 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] lspostgis.sql shows errors
El Martes 20 Enero 2009 13:13, Obe, Regina escribió:
> Strange.  Is it the same error as you got before?
> What does
> SELECT * FROM pg_settings WHERE name = 'search_path'
> return.

It returns me postgis queries that are being running on parallel databases. 
PostGIS seem to work (well, works) on databases created before this error. 
Now I can't create new gis databases.

María Arias de Reyna Domínguez
Emergya Consultoría
postgis-users mailing list
postgis-users at postgis.refractions.net

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090120/5f9009a0/attachment.html>

More information about the postgis-users mailing list