[MAPSERVER-USERS] Connection parameter errors while using Postgres DB Schema

[ritesh ambastha]

Venkat,

I am looking for that "some setting" :)

Cheers,
Ritesh

On Wed, Jul 16, 2008 at 3:23 PM, Venkat Rao Tammineni <
vtammineni at roulacglobal.com> 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: mapserver-users-bounces at lists.osgeo.org
> [mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of Ritesh
> Ambastha
> Sent: Wednesday, July 16, 2008 3:07 PM
> To: mapserver-users at 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: mapserver-users-bounces at lists.osgeo.org
> > [mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of Ritesh
> > Ambastha
> > Sent: Wednesday, July 16, 2008 2:44 PM
> > To: mapserver-users at 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 at lists.osgeo.org
> > http://lists.osgeo.org/mailman/listinfo/mapserver-users
> >
> > _______________________________________________
> > mapserver-users mailing list
> > mapserver-users at 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 at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20080716/ce85492e/attachment-0001.html