FW: [UMN_MAPSERVER-USERS] postgis schema

[Marcos Sánchez Provencio]

Have you tried this?
the_geom from (select * from hbDistrict.parcels) as p using SRID=4326
using unique gid

use your srid and primary key name.

Greetings from the antipodes

El lun, 03-09-2007 a las 14:35 +1200, Terence Maru escribió:
> Hi Barend, doesn't work for me.
> 
> <Mapscript - begin>
> $parcelLayer = ms_newLayerObj($map);
> $parcelLayer->set("connectiontype", MS_POSTGIS);
> $parcelLayer->set("name", "parcels");
> 
> $connector = "user=web dbname=districts host=localhost";
> $parcelLayer->set("connection", $connector);
> 
> $sql = "the_geom from hbDistrict.parcels";
> $parcelLayer->set("data", $sql);
> $parcelLayer->set("status", MS_DEFAULT);
> $parcelLayer->set("type", MS_LAYER_POLYGON);
> <Mapscript - end>
> 
> <Error - begin>
> Warning: [MapServer Error]: prepare_database(): Error executing POSTGIS DECLARE (the actual query) statement: 
> 'DECLARE mycursor BINARY CURSOR FOR SELECT asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::text from hbDistrict.parcels WHERE the_geom && setSRID('BOX3D(-180 -90,180 90)'::BOX3D, find_srid('','hbDistrict.parcels','the_geom') )' Postgresql reports the error as 'ERROR: function force_2d(hbDistrict.geometry) does not exist LINE 1: ...INARY CURSOR FOR SELECT asbinary(force_collection(force_2d(t... ^ HINT: No function matches the given name and argument types. You may need to add explicit type casts. ' More Help: Error with POSTGIS data variable. You specified 'check your .map file'. Standard ways of specifiying are : (1) 'geometry_column from geometry_table' (2) 'geometry_column from (sub query) as foo using unique column name using SRID=srid#' Make sure you put in the 'using unique column name' and 'using SRID=#' clauses in.
> <Error - end>
> 
> I have a database called districts, a schema called hbDistrict and a table called parcels.  I cannot set the search_path by using the data variable with "the_geom from hbDistrict.parcels".  I have created another database called test.  This database is created without schema's (public schema).  The data variable "the_geom from parcels" works (by works, I mean no errors).
> 
> bm
> 
> 
> -----Original Message-----
> From: Barend Köbben [mailto:kobben at itc.nl] 
> Sent: Monday, 3 September 2007 2:08 p.m.
> To: Terence Maru
> Subject: Re: [UMN_MAPSERVER-USERS] postgis schema
> 
> Just use the normal SQL 'prefixing' where eg. public.mytable is the table in the public schema, or myschema.mytable the same in another schema...
> 
> 
> __
> Barend Köbben
> International Institute for Geo-information Sciences and Earth Observation (ITC) PO Box 6, 7500AA Enschede (The Netherlands)
> ph: +31 (0)53 4874253; fax: +31 (0)53 4874335
> 
> 
> 
> On 03-09-2007 03:50, "Terence Maru" <terence at WAIROADC.GOVT.NZ> wrote:
> 
> > Hi all, im trying to connect to a postgres/postgis database.  The
> > connection process defines the database to connect to.  The data
> > variable defines the table and column (the_geom) to connect to.  How do
> > I tell mapserver to use a certain schema?  Thanks.
> >  
> > bm
> > 
> > ##############################################################################
> > #######
> > This e-mail message has been scanned for Viruses by McAfee and content has
> > been cleared by MailMarshal
> > ##############################################################################
> > #######
> 
> #####################################################################################
> This e-mail message has been scanned for Viruses by McAfee and content has
> been cleared by MailMarshal
> #####################################################################################