[postgis-users] View Problem - Version2

[Joao Brezolin]

Hello, 

 I'm using pgsql 7.2.3, PostGIS 0.7.3 and Mapserver
3.6.3

 I'm tried to create a view as this:


  LAYER
   CONNECTIONTYPE postgis
   NAME ruas
   CONNECTION "user=postgres dbname=dbase"
   DATA "geometry from area_log USING UNIQUE cod_log
 USING SRID=-1"
   FILTER "cod_sec=1"
   STATUS  ON
   TYPE LINE
 ....

where cod_log is the table primary key.

but it is not working at all. This error appear:

msPOSTGISLayerWhichShapes(): Query error.
prep_DB:Error executing POSTGIS DECLARE statement (0.6
failed - retried 0.5 and it failed too). DECLARE
mycursor BINARY CURSOR FOR SELECT
tipo_log::text,asbinary(force_collection(force_2d(geometry,cod_sec)),'NDR'),OID::text
from area_log FROM logradouro USING UNIQUE cod_log
USING SRID=-1 WHERE (cod_sec=1) and (geometry,cod_log
&& setSRID( 'BOX3D(1430.3002 760.3,1730.1002
1120.3)'::BOX3D,find_srid('','area_log FROM logradouro
USING UNIQUE cod_log USING
SRID=-1','geometria,cod_log') )) 



What could be wrong?

Thanks

João.


_______________________________________________________________________
Yahoo! Acesso Grátis
Internet rápida, grátis e fácil. Faça o download do discador agora mesmo.
http://br.acesso.yahoo.com/