[postgis-users] Update geometry_columns!

[André Cruvinel Resende]

Hello David and everybody,

Are you right, I've change the name of my tables.

How can i update the namos on my geometry_columns table?

Andre

Ps.: Sorry by creating another topic.

"
Hi 

I think it is because your table is not declared in
your geometry_columns table. MapServer can't find your
SRID in the geometry_columns

Try :

select * from geometry_columns 

and see if 
you find something like

f_table_name       f_geometry_column    srid

unidade_federativa  geom                ...


So tell me.

David

 --- André Cruvinel Resende
<andrecruvinel at yahoo.com.br> a écrit : > 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/
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
>
http://postgis.refractions.net/mailman/listinfo/postgis-users 

______________________________________________________________________

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