Dear Carlos, Never thought that it will be such easy. Thanks a ton! It worked :)
Regards, Ritesh Ambastha Carlos Ruiz-5 wrote: > > Ritesh, > > There's a way to stablish the default schema to a postgres user when it > connects, maybe this can help you to pull the data from postgres. > > To check what's the current default user's schema, you need to execute > this: > > SHOW search_path > > It must throw $user, public > > So, to set the default user's schema, you execute this: > > ALTER USER <user_name> SET search_path TO <schema_name> > > I suggest you to create a new role to connect to the database via map > file, and then > change its default schema. > > Another thing (maybe this was the first step) is to check if the user > postgres is the owner > of the schema, and if it's not, then check if it haves the USAGE privilege > on it. > > Hope this information helps > > IC Carlos Ruiz > > > --- On Wed, 7/16/08, Ritesh Ambastha <[EMAIL PROTECTED]> wrote: > > From: Ritesh Ambastha <[EMAIL PROTECTED]> > Subject: RE: [MAPSERVER-USERS] Connection parameter errors while using > Postgres DB Schema > To: mapserver-users@lists.osgeo.org > Date: Wednesday, July 16, 2008, 4:37 AM > > 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-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 > > -- View this message in context: http://www.nabble.com/Connection-parameter-errors-while-using-Postgres-DB-Schema-tp18483547p18505303.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