[Mapserver-users] mapserver+postgis schema

[Alessio Ferrario]

Myabe found a solution...

ALTER USER test SET search_path TO bar,foo;

Thanks to all
Ciao
Alessio

Il ven, 2004-04-23 alle 16:31, Alessio Ferrario ha scritto:
> Hi,
> first of all thaks for your reply.
> I follow yuor suggestion, but unfortunately no luck,I've still the same
> problem.
> Now my map filelook like this :
> ....
> LAYER
>  NAME "isone"
>  STATUS ON
>  TYPE POLYGON
>  CONNECTIONTYPE POSTGIS
>  CONNECTION "user=postgres  dbname=test_cc host=192.168.0.1 port=5432"
>  DATA "the_geom from cc.pippo_iso  UNIQUE oid using SRID=-1"
> ....
> 
> This is the error reported by mapserver when i try to use the schema:
> --------
> msDrawMap(): Image handling error. Failed to draw layer named 'isone'. 
> prep_DB(): Query error. Error executing POSTGIS DECLARE (the actual
> query) statement: 'DECLARE mycursor BINARY CURSOR FOR SELECT
> tipo::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),OID::text from cc.pippo_iso UNIQUE oid WHERE the_geom && setSRID('BOX3D(527833.85 5040987,552290.15 5065452)'::BOX3D, -1 )' 
> 
> Postgresql reports the error ''
> 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....
> 
> in my postgres log i see:
> -----
> 2004-04-23 14:47:54 [14740]  ERROR:  Function force_2d(cc.geometry) does
> not exist
>         Unable to identify a function that satisfies the given argument
> types
>         You may need to add explicit typecasts
> 2004-04-23 14:47:54 [14740]  LOG:  statement: DECLARE mycursor BINARY
> CURSOR FOR SELECT
> tipo::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),oid::text from cc.pippo_iso WHERE the_geom && setSRID('BOX3D(514064 5033607,515064 5034607)'::BOX3D, -1 )
> ---- 
> It's seems I've no declared the function, but I've the function in my
> schema "cc".
> Maybe we have to declare in some way the "search_path" variable...
> 
> Any idea?
> thanks to all
> Ciao
> Alessio
> 
> P.S.
> obviously whne i use "public" schema all work fine 
> 
> 
> 
> 
> Il gio, 2004-04-22 alle 16:33, Alexandros Chimarios ha scritto:
> > Also add the index oid on your query like this :
> > 
> > DATA "the_geom from gis.it_iso using UNIQUE oid using SRID=-1"
> > 
> > 
> > Please notice that you should have created the indexes (oid, srid)
> > on your DB. Please refer to the PostGIS manual.
> > 
> > 
> > 
> > On Thursday 22 April 2004 16:50, Alessio Ferrario wrote:
> > > Hi all,
> > > Can I use schema in a postgres layer?
> > > my map file look like this:
> > > ....
> > > CONNECTIONTYPE POSTGIS
> > > CONNECTION "user=dbuser  dbname=ITALIA33  host=192.168.0.1 port=5432"
> > > DATA "the_geom from gis.it_iso using SRID=-1"
> > > ....
> > >
> > > I software configuration is:
> > > postgres 7.3.4 running on Red Hat Linux 9
> > > mapserver 4.0
> > > php 4.3.4
> > > apache 2.0.47
> > >
> > > thanks in advance
> > > best regards
> > > Alessio
-- 
Alessio Ferrario
e-mail: alessio.f at cost.it
Work: +39-02-454461   
Fax +39-02-45446333