Não estou conseguindo conectar com o BD POSTGIS
Apresenta o seguinte erro:
Testando: temas/loc3.map Problemas ao gerar o mapa Error in %s: %s msDrawMap()Failed to draw layer named 'loc3'. Error in %s: %s msPostGISLayerWhichShapes()Error executing query: ERROR: function st_force_2d(geometry) does not exist LINE 1: select encode(ST_AsBinary(ST_Force_2D("geom"),'NDR'),'hex') ... ^ HINT: No function matches the given name and argument types. You may need to add explicit type casts.
Segue abaixo o mapfile
MAP
FONTSET "../symbols/fontes.txt"
SYMBOLSET "../symbols/simbolosv6.sym"
LAYER
CONNECTION "password=123 user=usuario dbname=spu host=localhost port=5432"
CONNECTIONTYPE POSTGIS
DATA "geom from (select gid,obs,orgao,processo,relatorio,rip,gid,geom from public.localizador_wgs) as foo using unique gid using srid=4326"
METADATA
"METAESTAT_ID_MEDIDA_VARIAVEL" ""
"cache" ""
"CLASSE" "SIM"
"METAESTAT_CODIGO_TIPO_REGIAO" ""
"metaestat" ""
"TEMA" "loc3"
"convcaracter" ""
END # METADATA
NAME "loc3"
PROJECTION
"init=epsg:4326"
END # PROJECTION
STATUS OFF
TEMPLATE "none.htm"
TYPE LINE
UNITS METERS
CLASS
NAME ""
STYLE
ANGLE 0
COLOR 0 0 0
OFFSET 0 0
SIZE 12
END # STYLE
END # CLASS
END # LAYER
END # MAP
Autor: dario neto
44 comentários