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
