Problems with MapServer and Postgis - find_srid()

[Leonardo Lamarca]

Hi everyone!

I need a help! I am running Mapserver 4.6.0 in Linux with PostgreSQL 
7.4.5 and Postgis 1.0.3
I am trying to run my first web-map application using Postgis. When I 
call de mapfile, MapServer return this error below.

I have an web-map application running with shape files. I converted 
these shape files to PostgreSQL using shp2pgsql and change mapfile to 
connect and get data through PostgreSQL.

Regards,
Leonardo Lamarca

=========================================================

msDrawMap(): Image handling error. Failed to draw layer named 'uf'.
prepare_database(): Query error. Error executing POSTGIS DECLARE (the 
actual query) statement: 'DECLARE mycursor BINARY CURSOR FOR SELECT 
REGIAO::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),OID::text 
from public.br_uf WHERE the_geom && setSRID('BOX3D(-79.1998333333333 
-33.751,-27.1691666666667 5.272)'::BOX3D, find_srid('','public.br_uf 
','the_geom') )'

Postgresql reports the error as 'ERROR: find_srid() - couldnt find the 
corresponding SRID - is the geometry registered in the GEOMETRY_COLUMNS 
table? Is there an uppercase/lowercase missmatch? '

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.

For more help, please see http://postgis.refractions.net/documentation.php

Mappostgis.c - version of Jan 23/2004.

================================================================

Part of my mapfile:


MAP
    NAME                "my2ndmap"
    EXTENT            -73.991 -33.751 -32.378 5.272
    FONTSET        "fontset.txt"
    IMAGETYPE        PNG
    #SHAPEPATH    "mapas"
    SIZE                600 450
    SYMBOLSET    "symbolset.sym"
    STATUS            ON
    UNITS            DD # sim. é necessário especificar a unidade de 
medida usada pelo MAP->PROJECTION
   
    #~ PROJECTION
        #~ "init=epsg:4291" # <4291> +proj=longlat +ellps=GRS67 
+towgs84=-57,1,-41,0,0,0,0  no_defs <>
    #~ END
   
    WEB
        IMAGEPATH        "/var/www/html/my2ndmap/tmp/"
        IMAGEURL        "/my2ndmap/tmp/"
        MINSCALE        25000
        MAXSCALE        35000000
        TEMPLATE        "web_template.html"
        HEADER            "web_header.html"
        FOOTER            "web_footer.html"
        LOG            "/var/www/html/my2ndmap/log"
    END
   
    QUERYMAP
        COLOR            0 0 255
        SIZE                300 225
        STATUS            ON
        STYLE            HILITE
    END
   
    LEGEND
        IMAGECOLOR        255 255 255
        POSITION        UR
        KEYSIZE         12 10
        STATUS             ON
        LABEL
            ANTIALIAS    TRUE
            SIZE        SMALL
            TYPE        BITMAP
            COLOR        0 0 0
        END
    END
   
    REFERENCE
        COLOR                -1 -1 -1
        EXTENT                -73.991 -33.751 -32.378 5.272
        IMAGE                "br_refmap.png"
        MAXBOXSIZE        119
        OUTLINECOLOR    255 0 0
        SIZE                    120 90
        STATUS                ON   
    END
   
    SCALEBAR
        COLOR                255 0 0
        INTERVALS            3
        OUTLINECOLOR    0 0 0
        POSITION            LR
        SIZE                    200 3
        STATUS                EMBED
        STYLE                0
        UNITS                KILOMETERS
        LABEL
            ANTIALIAS        TRUE
            SIZE                SMALL
            TYPE                BITMAP
            COLOR            0 0 0
        END
    END
   
   
    LAYER # uf
        #~ PROJECTION
            #~ "init=epsg:4291" # <4291> +proj=longlat +ellps=GRS67 
+towgs84=-57,1,-41,0,0,0,0  no_defs <>
        #~ END
        NAME                    "uf"
        DEBUG on
        CONNECTIONTYPE postgis
        CONNECTION "user=[*******] password=[*******] dbname=gis_teste01 
host=localhost"
        TYPE                    POLYGON
        DATA                    "the_geom from public.br_uf "
        STATUS                DEFAULT
        CLASSITEM            "REGIAO"
        CLASS
            NAME                    "Norte"
            EXPRESSION        "NORTE"
            OUTLINECOLOR    46 92 92
            COLOR                 0 192 0
        END
        CLASS
            NAME                    "Nordeste"
            EXPRESSION        "NORDESTE"
            OUTLINECOLOR    46 92 92
            COLOR                192 192 192
        END
        CLASS
            NAME                    "Centroeste"
            EXPRESSION        "CENTROESTE"
            OUTLINECOLOR    46 92 92
            COLOR                255 128 128
        END
        CLASS
            NAME                    "Sudeste"
            EXPRESSION        "SUDESTE"
            OUTLINECOLOR    46 92 92
            COLOR                255 255 128
        END
        CLASS
            NAME                    "Sul"
            EXPRESSION        "SUL"
            OUTLINECOLOR    46 92 92
            COLOR                128 128 255
        END
    END

(....)