<div>Hi Fran, hi Vladimir,</div>
<div> </div>
<div>thanks for the input. </div>
<div>I think Fran is right with changing the fieldname "length" to something else.</div>
<div>I ruled out any typos and also the table name should be no problem.</div>
<div>My server is not public and I will have a look at my database in the evening.</div>
<div>
<div>Regarding the geometry_columns table in Postgis everthing is fine.</div>
<div> </div></div>
<div>Many thanks so far,</div>
<div> </div>
<div>Johannes<br></div>
<div class="gmail_quote">2009/10/13 Vladimir Peric <span dir="ltr"><<a href="mailto:vladimir.peric@beogis.com">vladimir.peric@beogis.com</a>></span><br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">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
<div>
<div></div>
<div class="h5"><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" target="_blank">spatialjoe@googlemail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
<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><br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">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" 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></blockquote></div><br><br clear="all"><br></div>
</div>-- <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" target="_blank">vladimir.peric@beogis.com</a><br>
skype: vlada.peric<br>site: <a href="http://www.beogis.com/" target="_blank">www.beogis.com</a><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>