<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7653.38">
<TITLE>RE: [postgis-users] lspostgis.sql shows errors</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>Maria,<BR>
<BR>
I don't quite understand your answer. I meant what does it return. I guess<BR>
this might be simpler.<BR>
<BR>
SELECT setting FROM pg_settings WHERE name = 'search_path'<BR>
<BR>
On my working databases this should return for setting<BR>
<BR>
"$user",public<BR>
<BR>
<BR>
I was thinking that maybe for some reason on the database that is not working yours is returning<BR>
<BR>
pg_catalog,"$user", public<BR>
<BR>
<BR>
or is not returning any answer<BR>
which would possibly explain why it is trying to<BR>
write to the pg_catalog database.<BR>
<BR>
Hope that helps,<BR>
Regina<BR>
<BR>
<BR>
-----Original Message-----<BR>
From: postgis-users-bounces@postgis.refractions.net on behalf of Maria Arias de Reyna<BR>
Sent: Tue 1/20/2009 10:01 AM<BR>
To: PostGIS Users Discussion<BR>
Subject: Re: [postgis-users] lspostgis.sql shows errors<BR>
<BR>
El Martes 20 Enero 2009 13:13, Obe, Regina escribió:<BR>
> Strange. Is it the same error as you got before?<BR>
><BR>
> What does<BR>
><BR>
> SELECT * FROM pg_settings WHERE name = 'search_path'<BR>
><BR>
> return.<BR>
<BR>
It returns me postgis queries that are being running on parallel databases.<BR>
PostGIS seem to work (well, works) on databases created before this error.<BR>
Now I can't create new gis databases.<BR>
<BR>
--<BR>
María Arias de Reyna Domínguez<BR>
Emergya Consultoría<BR>
_______________________________________________<BR>
postgis-users mailing list<BR>
postgis-users@postgis.refractions.net<BR>
<A HREF="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR>
<BR>
</FONT>
</P>
</BODY>
</HTML>
<HTML><BODY><P><hr size=1></P>
<P><STRONG>
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.
</STRONG></P></BODY></HTML>
<P><hr size=1></P>
<P><STRONG><font size="2" color="339900"> Help make the earth a greener place. If at all possible resist printing this email and join us in saving paper. </p> <p> </font></STRONG></P>