[postgis-users] Re: postgis-users Digest, Vol 16, Issue 20

[André Cruvinel Resende]

Hi,

I'm using:

RedHat 9
mapserver-4.0.1
postgres-7.3.2
postgis-0-8-1

I load the geographic data using shp2pgsql.

When i try to load the layer "unidade_federativa", the
postgres return this error.

msDrawMap(): Image handling error. Failed to draw layer
named 'unidade_federativa'.
prep_DB(): Query error. Error executing POSTGIS DECLARE
(the actual query) statement: 'DECLARE mycursor BINARY
CURSOR FOR SELECT
asbinary(force_collection(force_2d(geom)),'NDR'),OID::text
from unidade_federativa WHERE geom &&
setSRID('BOX3D(-58.9171479166667 -30.9797,-47.6857979166667
-19.7447)'::BOX3D,
find_srid('','unidade_federativa','geom') )'

The layer definitions on my map file are:
 
LAYER
  CONNECTIONTYPE postgis
  NAME "unidade_federativa"
  TYPE POLYGON
  CONNECTION "user=usuario password=senha
dbname=sig_cartafrete host=localhost"
  DATA "geom from unidade_federativa"
  STATUS ON
  CLASS
    COLOR -1 -1 -1
    OUTLINECOLOR 0 0 0
  END
END

Any idea of what could be wrong?

[]'s

Andre



______________________________________________________________________

Yahoo! GeoCities: 15MB de espaço grátis para criar seu web site!
http://br.geocities.yahoo.com/