Problems with MapServer and Postgis - find_srid()

[Paul Scott]

Leonardo,

Try and leave off the <schema> part of the data connection. i.e.  
Change 

DATA                    "the_geom from public.br_uf "

to:

DATA                    "the_geom from br_uf "

--Paul 

>>> Leonardo Lamarca <lamarca at ACQUASOFTWARE.COM.BR> 08/11/05 8:16 PM >>>
   
   
    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