Venkat, I am looking for that "some setting" :)
Cheers, Ritesh On Wed, Jul 16, 2008 at 3:23 PM, Venkat Rao Tammineni < [EMAIL PROTECTED]> wrote: > 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<http://www.nabble.com/Connection-parameter-errors-while-using-Postgres-DB-Schema-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