<table cellspacing='0' cellpadding='0' border='0' ><tr><td valign='top' style='font: inherit;'><P>Ritesh,</P>
<P> </P>
<P>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.</P>
<P> </P>
<P>To check what's the current default user's schema, you need to execute this:</P>
<P> </P>
<P>SHOW search_path</P>
<P> </P>
<P>It must throw $user, public</P>
<P> </P>
<P>So, to set the default user's schema, you execute this:</P>
<P> </P>
<P>ALTER <SPAN class=highlight1>USER</SPAN> <user_name> SET search_path TO <schema_name></P>
<P> </P>
<P>I suggest you to create a new role to connect to the database via map file, and then </P>
<P>change its default schema.</P>
<P> </P>
<P>Another thing (maybe this was the first step) is to check if the user postgres is the owner </P>
<P>of the schema, and if it's not, then check if it haves the USAGE privilege on it.</P>
<P> </P>
<P>Hope this information helps<BR></P>
<DIV><STRONG><FONT color=#0000bf>IC Carlos Ruiz</FONT></STRONG></DIV>
<DIV><STRONG><FONT color=#0000bf></FONT></STRONG> </DIV><BR><BR>--- On <B>Wed, 7/16/08, Ritesh Ambastha <I><group.ritesh@gmail.com></I></B> wrote:<BR>
<BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: rgb(16,16,255) 2px solid">From: Ritesh Ambastha <group.ritesh@gmail.com><BR>Subject: RE: [MAPSERVER-USERS] Connection parameter errors while using Postgres DB Schema<BR>To: mapserver-users@lists.osgeo.org<BR>Date: Wednesday, July 16, 2008, 4:37 AM<BR><BR><PRE>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@lists.osgeo.org
> [mailto:mapserver-users-bounces@lists.osgeo.org] 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</PRE></BLOCKQUOTE></td></tr></table><br>