<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'><font style="font-size:12pt;" face="Times New Roman,sans-serif" color="#000000" size="3"><br id="FontBreak"></font>Dear all,<br>I have a problem connecting to a PG db with v.external. I created a view on the db (sanfgrass_rain2h) which has a geometry column and grass is able to see it, but when I try to execute v.external it gives me an error about the geometry. See attached lines.<br>It seems that the layer is correctly detected but no geometry is imported, even if more tha 3000 points are provided by the view. Moreover I have checked that the view is correctly shown in the geometry_columns view.<br>There is an alert concerning the primary key but, AFAIK, it is not possible to define it in a view .<br><br>Thanks for any help,<br>Mary<br><br><font style="" face="Times New Roman,sans-serif">db.connect driver=pg database="XXX,dbname=YYY,port=5432";</font><br><p class="ecxMsoAutoSig"><font style="font-size:10pt;" face="Times New Roman" size="2"><span><font style="font-size: 12pt;" size="3">v.external input="PG:host=XXX user=postgres dbname=YYY" -lt;<br></font><font style="font-size: 12pt;" size="3">PostGIS database <YYY> contains 64 feature tables:</font><font style="font-size: 12pt;" size="3"><br></font><font style="font-size: 12pt;" size="3">anagrafica,point,0,the_geom</font><font style="font-size: 12pt;" size="3"><br></font><font style="font-size: 12pt;" size="3">.</font></span></font></p><p class="ecxMsoAutoSig"><font style="font-size:10pt;" face="Times New Roman" size="2"><span><font style="font-size: 12pt;" size="3">.</font></span></font></p><p class="ecxMsoAutoSig"><font style="font-size:10pt;" face="Times New Roman" size="2"><span><font style="font-size: 12pt;" size="3">.</font></span></font></p><p class="ecxMsoAutoSig"><font style="font-size:10pt;" face="Times New Roman" size="2"><span><font style="font-size: 12pt;" size="3"></font><font style="font-size: 12pt;" size="3"><br></font><font style="font-size: 12pt;" size="3">sanfgrass_rain2h,geometry,0,the_geom</font><font style="font-size: 12pt;" size="3"><br></font><font style="font-size: 12pt;" size="3">.</font></span></font></p><p class="ecxMsoAutoSig"><font style="font-size:10pt;" face="Times New Roman" size="2"><span><font style="font-size: 12pt;" size="3">.</font></span></font></p><p class="ecxMsoAutoSig"><font style="font-size:10pt;" face="Times New Roman" size="2"><span><font style="font-size: 12pt;" size="3">.</font></span></font></p><p class="ecxMsoAutoSig"><font style="font-size:10pt;" face="Times New Roman" size="2"><span><font style="font-size: 12pt;" size="3">v.external input="PG:host=XXX user=postgres dbname=YYY" layer=sanfgrass_rain2h;</font><font style="font-size: 12pt;" size="3"><br></font><font style="font-size: 12pt;" size="3">ATTENZIONE: No key column detected.</font><font style="font-size: 12pt;" size="3"><br></font><font style="font-size: 12pt;" size="3">ATTENZIONE: Feature table <sanfgrass_rain2h> has no primary key defined.</font><font style="font-size: 12pt;" size="3"><br></font><font style="font-size: 12pt;" size="3"> Unable to define DB links.</font><font style="font-size: 12pt;" size="3"><br></font><font style="font-size: 12pt;" size="3">Si sta ricreando la topologia per il vettore <sanfgrass_rain2h@test_4>...</font><font style="font-size: 12pt;" size="3"><br></font><font style="font-size: 12pt;" size="3">Numero di nodi: 0</font><font style="font-size: 12pt;" size="3"><br></font><font style="font-size: 12pt;" size="3">Numero di primitive: 0</font><font style="font-size: 12pt;" size="3"><br></font><font style="font-size: 12pt;" size="3">Numero di punti: 0</font><font style="font-size: 12pt;" size="3"><br></font><font style="font-size: 12pt;" size="3">Numero di linee: 0</font><font style="font-size: 12pt;" size="3"><br></font><font style="font-size: 12pt;" size="3">Numero di confini: 0</font><font style="font-size: 12pt;" size="3"><br></font><font style="font-size: 12pt;" size="3">Numero di centroidi: 0</font><font style="font-size: 12pt;" size="3"><br></font><font style="font-size: 12pt;" size="3">Numero di aree: -</font><font style="font-size: 12pt;" size="3"><br></font><font style="font-size: 12pt;" size="3">Numero di isole: -</font><font style="font-size: 12pt;" size="3"><br></font><font style="font-size: 12pt;" size="3">v.external completo. Link to vector map <s</font></span></font><font style="font-size:10pt;" face="Times New Roman" size="2"><span><font style="font-size: 12pt;" size="3"><font style="font-size:10pt;" face="Times New Roman" size="2"><span><font style="font-size: 12pt;" size="3">anfgrass_rain2h</font></span></font>> created.</font><br></span></font></p> </div></body>
</html>