[Gvsig_english] gvSIG 1.1.2 and 1.9 (1245): Can't load postgis-layer

[Francisco José Peñarrubia]

Hi Johannes.

To know the reason, it would be good to have access to this layer (is 
your server public?).
If not, I would check 3 things:

1.- Be sure you have write well the name of the table in "geometry_columns".
2.- Change the name of the "length" field and use some other word, for 
example "shapelength"
3.- Try to change the name of the table (use only upper case, for example).

Hope it helps.

Cheers.

Fran Peñarrubia
www.scolab.es

Johannes Valenta escribió:
> Hi Virginia,
> thank you for responding. I am not able to choose the geometry column 
> within the listbox - it just stays blank. That's the problem.
> What could be the reason?
> Best,
>  
> Johannes
>
> 2009/10/13 virginia morales segura <morales_vir at gva.es 
> <mailto:morales_vir at gva.es>>
>
>     Hi Johannes,
>
>     you must can to choose your geometry column at listbox of geometry. If
>     you say that you have the column type geometry, you should choose it.
>     Can you send us the layer that goes wrong.
>
>     Regards.
>
>
>     Johannes Valenta escribió:
>     > Hi list,
>     >
>     > today I encountered a strange phenomenon. I tried to load a
>     > postgis-layer into projects of both versions (1.1.2, 1.9 build1245)
>     > which did not work.
>     > In both versions the geometry column would not show up in the
>     > corresponding field although I registered the layer in the "geometry
>     > columns" table in postgis as usual.
>     > All other layers within my database work fine.
>     > These are the columns of my layer:
>     >   pid integer,
>     >   highway text,
>     >   tracktype text,
>     >   label3 text,
>     >   belag numeric,
>     >   wegbreite numeric,
>     >   landnutz numeric,
>     >   length double precision,
>     >   the_geom geometry,
>     >   summe integer,
>     >   pid1 serial NOT NULL
>     >
>     > Exporting the layer from postgis to shp and adding it to gvSIG works
>     > (so I obviously did not mess up the geometry type).
>     > Any ideas /hints?
>     >
>     > Best,
>     >
>     > Johannes
>     >
>     ------------------------------------------------------------------------
>     >
>     > _______________________________________________
>     > Gvsig_internacional mailing list
>     > Gvsig_internacional at listserv.gva.es
>     <mailto:Gvsig_internacional at listserv.gva.es>
>     > http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional
>     >
>
>     _______________________________________________
>     Gvsig_internacional mailing list
>     Gvsig_internacional at listserv.gva.es
>     <mailto:Gvsig_internacional at listserv.gva.es>
>     http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Gvsig_internacional mailing list
> Gvsig_internacional at listserv.gva.es
> http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional
>