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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ritesh Ambastha Sent: Wednesday, July 16, 2008 3:07 PM To: mapserver-users@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: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Ritesh > Ambastha > Sent: Wednesday, July 16, 2008 2:44 PM > To: mapserver-users@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@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapserver-users > > _______________________________________________ > mapserver-users mailing list > mapserver-users@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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users _______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users