[MAPSERVER-USERS] Connection parameter errors while using Postgres DB Schema

[Venkat Rao Tammineni]

Hi,

   Have you checked other schema? See you can use either public or pg_temp_1
right ? if you want to use pg_temp_1 schema u need to have some setting
while configuring at add new server connection. This is only as per
knowledge. I did not tested. And my suggestion is  Use "Pulic".Because ,if
there any joining among the table ,that would be again problem.

   If I am not right ,let me know.

Thanks and Regards
Venkat.

-----Original Message-----
From: mapserver-users-bounces at lists.osgeo.org
[mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of Ritesh
Ambastha
Sent: Wednesday, July 16, 2008 3:07 PM
To: mapserver-users at lists.osgeo.org
Subject: RE: [MAPSERVER-USERS] Connection parameter errors while using
Postgres DB Schema


Hey Venkat,

Thanks for the details. 
I understand the standard way to write a connection parameter. 

I am sure that this table "rgp_gis_gmm_100_metros" is stored in "public"
schema of your database. 

My question is, what will you write if you keep this table in some other
schema?

Regards,


Venkatrao wrote:
> 
> Hi,
> Here is my Example .I think it helps you.
> 
> Layer # Layer starts here
>   Name "GMM 100" #name of the layer
>   ConnectionType POSTGIS #connection type
>   Connection "host=192.168.1.158 dbname=GIS password=administrator
> user=postgres port=5432" #connection type.
>   Data "the_geom from rgp_gis_gmm_100_metros"   #table name
> 
> Thanks and Regards
> Venkat.
> 
> 
> 
> 
> 
> -----Original Message-----
> From: mapserver-users-bounces at lists.osgeo.org
> [mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of Ritesh
> Ambastha
> Sent: Wednesday, July 16, 2008 2:44 PM
> To: mapserver-users at lists.osgeo.org
> Subject: [MAPSERVER-USERS] Connection parameter errors while using
> Postgres
> DB Schema
> 
> 
> Hello Readers, 
> 
> I am facing a problem in defining the DATA path in mapserver while using
> PostGIS. 
> 
> I have two schemas, lets say 'a' and 'b' in a database 'd'
> 
> Now, I want to access tables of schema 'a' in the mapserver layer. 
> 
> I define DATA path like this: 
> 
> DATA "the_geom FROM a.table_name USING UNIQUE id SRID -1" 
> 
> Please pour in your thoughts for defining schema in the connection/data
> parameters.
> 
> Thanks,
> Ritesh Ambastha
> -- 
> View this message in context:
>
http://www.nabble.com/Connection-parameter-errors-while-using-Postgres-DB-Sc
> hema-tp18483547p18483547.html
> Sent from the Mapserver - User mailing list archive at Nabble.com.
> 
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
> 
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
> 
> 

-- 
View this message in context:
http://www.nabble.com/Connection-parameter-errors-while-using-Postgres-DB-Sc
hema-tp18483547p18483876.html
Sent from the Mapserver - User mailing list archive at Nabble.com.

_______________________________________________
mapserver-users mailing list
mapserver-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users