Hi,<br><br>I had the same problem and here is what solved the problem in my case. In order GvSig to recognize the table as a layer candidate, there should exist a table in PostreSQL, named <b>geometry_columns</b>. For each table in the database that has a geometry column, a corresponding row in the table <b>geometry_columns</b> should be present. The row in this table can be manually added if needed.<br>
<br>Hope this will help.<br><br>Cheers,<br>Vladimir<br> <br><br><br><br><div class="gmail_quote">On Tue, Oct 13, 2009 at 9:22 AM, Johannes Valenta <span dir="ltr"><<a href="mailto:spatialjoe@googlemail.com">spatialjoe@googlemail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div>Hi Virginia, <br>thank you for responding. I am not able to choose the geometry column within the listbox - it just stays blank. That's the problem.<br>
What could be the reason?<br></div>
<div>Best,</div>
<div> </div>
<div>Johannes<br><br></div>
<div class="gmail_quote">2009/10/13 virginia morales segura <span dir="ltr"><<a href="mailto:morales_vir@gva.es" target="_blank">morales_vir@gva.es</a>></span><div><div></div><div class="h5"><br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0px 0px 0px 0.8ex; padding-left: 1ex;">Hi Johannes,<br><br>you must can to choose your geometry column at listbox of geometry. If<br>
you say that you have the column type geometry, you should choose it.<br>
Can you send us the layer that goes wrong.<br><br>Regards.<br><br><br>Johannes Valenta escribió:<br>
<div>
<div></div>
<div>> Hi list,<br>><br>> today I encountered a strange phenomenon. I tried to load a<br>> postgis-layer into projects of both versions (1.1.2, 1.9 build1245)<br>> which did not work.<br>> In both versions the geometry column would not show up in the<br>
> corresponding field although I registered the layer in the "geometry<br>> columns" table in postgis as usual.<br>> All other layers within my database work fine.<br>> These are the columns of my layer:<br>
> pid integer,<br>> highway text,<br>> tracktype text,<br>> label3 text,<br>> belag numeric,<br>> wegbreite numeric,<br>> landnutz numeric,<br>> length double precision,<br>> the_geom geometry,<br>
> summe integer,<br>> pid1 serial NOT NULL<br>><br>> Exporting the layer from postgis to shp and adding it to gvSIG works<br>> (so I obviously did not mess up the geometry type).<br>> Any ideas /hints?<br>
><br>> Best,<br>><br>> Johannes<br></div></div>> ------------------------------------------------------------------------<br>><br>> _______________________________________________<br>> Gvsig_internacional mailing list<br>
> <a href="mailto:Gvsig_internacional@listserv.gva.es" target="_blank">Gvsig_internacional@listserv.gva.es</a><br>> <a href="http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional" target="_blank">http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional</a><br>
><br><br>_______________________________________________<br>Gvsig_internacional mailing list<br><a href="mailto:Gvsig_internacional@listserv.gva.es" target="_blank">Gvsig_internacional@listserv.gva.es</a><br><a href="http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional" target="_blank">http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional</a><br>
</blockquote></div></div></div><br>
<br>_______________________________________________<br>
Gvsig_internacional mailing list<br>
<a href="mailto:Gvsig_internacional@listserv.gva.es">Gvsig_internacional@listserv.gva.es</a><br>
<a href="http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional" target="_blank">http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>Vladimir Periĉ<br>General Manager<br>BEOGIS d.o.o. Beograd<br>Milutina Milankoviĉa 130/109, Novi Beograd<br><br>mob: +381642040889<br>tel: +381112122810<br>mail: <a href="mailto:vladimir.peric@beogis.com">vladimir.peric@beogis.com</a><br>
skype: vlada.peric<br>site: <a href="http://www.beogis.com">www.beogis.com</a><br>