<div dir="ltr">Hi Markus,<div><br></div><div>OK here is the result of v.db.connect -p</div><div> <br></div><div><div>v.db.connect -p APGB_aerial_2_i_segment_drained_peat_with_exposed_haggs_vector </div><div>Vector map <APGB_aerial_2_i_segment_drained_peat_with_exposed_haggs_vector> is connected by:</div><div>layer <1/grass_gis.APGB_aerial_2_i_segment_drained_peat_with_exposed_haggs_vector> table <grass_gis.APGB_aerial_2_i_segment_drained_peat_with_exposed_haggs_vector> in database <webgis> through driver <pg> with key <cat></div><div><br></div></div><div>I recall some years ago you had to delete the 'db.login' file and recreate it but this would lose the connection to the vector layer attribute table (sqlite.db).</div><div><br></div><div>Thanks,</div><div><br></div><div>Paul Shapley</div></div><div class="gmail_extra"><br><div class="gmail_quote">On 28 June 2018 at 13:22, Markus Metz <span dir="ltr"><<a href="mailto:markus.metz.giswork@gmail.com" target="_blank">markus.metz.giswork@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><br><br>On Thu, Jun 28, 2018 at 1:40 PM, Moritz Lennert <<a href="mailto:mlennert@club.worldonline.be" target="_blank">mlennert@club.worldonline.be</a>> wrote:<br>><br>> On 28/06/18 09:59, Paul Shapley wrote:<br>>><br>>> Hi,<br>>><br>>> I am trying to export a vector map to PostGIS. Has anyone come across the 'Unable to describe table' error? I suspect my config could be wrong.<br>>><br>>> v.out.postgis --overwrite input=APGB_aerial_2_i_segment_<wbr>drained_peat_with_exposed_<wbr>haggs_vct@PERMANENT output=PG:dbname=webgis output_layer=APGB_aerial_2_i_<wbr>segment_drained_peat_with_<wbr>exposed_haggs_vct options=FID=cat, GEOMETRY_NAME=wkb_geometry, SPATIAL_INDEX=YES, PRIMARY_KEY=YES<br>>> DBMI-PostgreSQL driver error:<br>>> select * from grass_gis.APGB_aerial_2_i_<wbr>segment_drained_peat<br>>> _with_exposed_haggs_vct where 1 = 0<br>>> ERROR: relation "grass_gis.apgb_aerial_2_i_<wbr>segment_drained_<br>>> peat_with_exposed_haggs_vct" does not exist<br>>> LINE 1: select * from<br>>> grass_gis.APGB_aerial_2_i_<wbr>segment_drained_peat...<br>>> ^<br>>> DBMI-PostgreSQL driver error:<br>>> select * from grass_gis.APGB_aerial_2_i_<wbr>segment_drained_peat<br>>> _with_exposed_haggs_vct where 1 = 0<br>>> ERROR: relation "grass_gis.apgb_aerial_2_i_<wbr>segment_drained_<br>>> peat_with_exposed_haggs_vct" does not exist<br>>> LINE 1: select * from<br>>> grass_gis.APGB_aerial_2_i_<wbr>segment_drained_peat...<br>>> ^<br>>> *ERROR: Unable to describe table* <grass_gis.APGB_aerial_2_i_<wbr>segment_drained_peat_with_<wbr>exposed_haggs_vct><br>><br>><br><div>> It looks like it is trying to read the input attrubute table from postgresql (schema grass_gis). Do you use PostgreSQL as attribute table backend ? Could you provide the output of db.connect -p in that mapset ?</div><div><br></div><div>ore precise would be</div><div>v.db.connect -p APGB_aerial_2_i_segment_<wbr>drained_peat_with_exposed_<wbr>haggs_vct@PERMANENT<br></div><div><br></div><div>because there may be a bug in v.out.postgis, not properly reading the database connection of the input vector.</div><div><br></div><div>Markus Metz</div><div><br></div>><br>> Moritz<br>><br>> ______________________________<wbr>_________________<br>> grass-user mailing list<br>> <a href="mailto:grass-user@lists.osgeo.org" target="_blank">grass-user@lists.osgeo.org</a><br>> <a href="https://lists.osgeo.org/mailman/listinfo/grass-user" target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/grass-user</a><br><br></div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><b>Paul J. Shapley </b><span style="font-family:times new roman,serif"><font size="2"><span style="font-family:arial,helvetica,sans-serif">MSc CGeog (GIS) FRGS</span></font><br></span><b><br></b></div></div>
</div>