[postgis-users] Update geometry_columns!

[David TECHER]

Hello

As I tell you in a mail I sent to you

if your table is not declared in geometry_columns
doesn't matter if you just add 

as foo using unique gid using SRID=-1

in DATA. do

DATA "geom from unidade_federativa as foo using unique
gid using SRID=-1"

and try mapserver to see your image.

if you have change the name of your geometry_columns
table do

alter table <youroldtable> rename to geometry_columns

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


	

	
		
Yahoo! Mail : votre e-mail personnel et gratuit qui vous suit partout ! 
Créez votre Yahoo! Mail sur http://fr.benefits.yahoo.com/