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

[Ritesh Ambastha]

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 <group.ritesh at gmail.com> wrote:
> 
> From: Ritesh Ambastha <group.ritesh at gmail.com>
> Subject: RE: [MAPSERVER-USERS] Connection parameter errors while using
> Postgres DB Schema
> To: mapserver-users at 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: 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-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
> 
> 
> 
> _______________________________________________
> 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-Schema-tp18483547p18505303.html
Sent from the Mapserver - User mailing list archive at Nabble.com.