<div dir="ltr">Venkat, <br><br>I am looking for that "some setting" :) <br><br>Cheers,<br>Ritesh<br><br><div class="gmail_quote">On Wed, Jul 16, 2008 at 3:23 PM, Venkat Rao Tammineni <<a href="mailto:vtammineni@roulacglobal.com">vtammineni@roulacglobal.com</a>> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi,<br>
<br>
Have you checked other schema? See you can use either public or pg_temp_1<br>
right ? if you want to use pg_temp_1 schema u need to have some setting<br>
while configuring at add new server connection. This is only as per<br>
knowledge. I did not tested. And my suggestion is Use "Pulic".Because ,if<br>
there any joining among the table ,that would be again problem.<br>
<br>
If I am not right ,let me know.<br>
<div class="Ih2E3d"><br>
Thanks and Regards<br>
Venkat.<br>
<br>
-----Original Message-----<br>
From: <a href="mailto:mapserver-users-bounces@lists.osgeo.org">mapserver-users-bounces@lists.osgeo.org</a><br>
[mailto:<a href="mailto:mapserver-users-bounces@lists.osgeo.org">mapserver-users-bounces@lists.osgeo.org</a>] On Behalf Of Ritesh<br>
Ambastha<br>
</div><div class="Ih2E3d">Sent: Wednesday, July 16, 2008 3:07 PM<br>
To: <a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br>
</div><div><div></div><div class="Wj3C7c">Subject: RE: [MAPSERVER-USERS] Connection parameter errors while using<br>
Postgres DB Schema<br>
<br>
<br>
Hey Venkat,<br>
<br>
Thanks for the details.<br>
I understand the standard way to write a connection parameter.<br>
<br>
I am sure that this table "rgp_gis_gmm_100_metros" is stored in "public"<br>
schema of your database.<br>
<br>
My question is, what will you write if you keep this table in some other<br>
schema?<br>
<br>
Regards,<br>
<br>
<br>
Venkatrao wrote:<br>
><br>
> Hi,<br>
> Here is my Example .I think it helps you.<br>
><br>
> Layer # Layer starts here<br>
> Name "GMM 100" #name of the layer<br>
> ConnectionType POSTGIS #connection type<br>
> Connection "host=<a href="http://192.168.1.158" target="_blank">192.168.1.158</a> dbname=GIS password=administrator<br>
> user=postgres port=5432" #connection type.<br>
> Data "the_geom from rgp_gis_gmm_100_metros" #table name<br>
><br>
> Thanks and Regards<br>
> Venkat.<br>
><br>
><br>
><br>
><br>
><br>
> -----Original Message-----<br>
> From: <a href="mailto:mapserver-users-bounces@lists.osgeo.org">mapserver-users-bounces@lists.osgeo.org</a><br>
> [mailto:<a href="mailto:mapserver-users-bounces@lists.osgeo.org">mapserver-users-bounces@lists.osgeo.org</a>] On Behalf Of Ritesh<br>
> Ambastha<br>
> Sent: Wednesday, July 16, 2008 2:44 PM<br>
> To: <a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br>
> Subject: [MAPSERVER-USERS] Connection parameter errors while using<br>
> Postgres<br>
> DB Schema<br>
><br>
><br>
> Hello Readers,<br>
><br>
> I am facing a problem in defining the DATA path in mapserver while using<br>
> PostGIS.<br>
><br>
> I have two schemas, lets say 'a' and 'b' in a database 'd'<br>
><br>
> Now, I want to access tables of schema 'a' in the mapserver layer.<br>
><br>
> I define DATA path like this:<br>
><br>
> DATA "the_geom FROM a.table_name USING UNIQUE id SRID -1"<br>
><br>
> Please pour in your thoughts for defining schema in the connection/data<br>
> parameters.<br>
><br>
> Thanks,<br>
> Ritesh Ambastha<br>
> --<br>
> View this message in context:<br>
><br>
<a href="http://www.nabble.com/Connection-parameter-errors-while-using-Postgres-DB-Sc" target="_blank">http://www.nabble.com/Connection-parameter-errors-while-using-Postgres-DB-Sc</a><br>
> hema-tp18483547p18483547.html<br>
> Sent from the Mapserver - User mailing list archive at Nabble.com.<br>
><br>
> _______________________________________________<br>
> mapserver-users mailing list<br>
> <a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br>
> <a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br>
><br>
> _______________________________________________<br>
> mapserver-users mailing list<br>
> <a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br>
> <a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br>
><br>
><br>
<br>
--<br>
View this message in context:<br>
<a href="http://www.nabble.com/Connection-parameter-errors-while-using-Postgres-DB-Schema-tp18483547p18483876.html" target="_blank">http://www.nabble.com/Connection-parameter-errors-while-using-Postgres-DB-Sc<br>
hema-tp18483547p18483876.html</a><br>
Sent from the Mapserver - User mailing list archive at Nabble.com.<br>
<br>
_______________________________________________<br>
mapserver-users mailing list<br>
<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br>
<br>
</div></div></blockquote></div><br></div>