[GRASS-user] v.out.postgis

[Markus Metz]

On Thu, Jun 28, 2018 at 1:40 PM, Moritz Lennert <
mlennert at club.worldonline.be> wrote:
>
> On 28/06/18 09:59, Paul Shapley wrote:
>>
>> Hi,
>>
>> 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.
>>
>> v.out.postgis --overwrite
input=APGB_aerial_2_i_segment_drained_peat_with_exposed_haggs_vct at PERMANENT
output=PG:dbname=webgis
output_layer=APGB_aerial_2_i_segment_drained_peat_with_exposed_haggs_vct
options=FID=cat, GEOMETRY_NAME=wkb_geometry, SPATIAL_INDEX=YES,
PRIMARY_KEY=YES
>> DBMI-PostgreSQL driver error:
>> select * from grass_gis.APGB_aerial_2_i_segment_drained_peat
>> _with_exposed_haggs_vct where 1 = 0
>> ERROR:  relation "grass_gis.apgb_aerial_2_i_segment_drained_
>> peat_with_exposed_haggs_vct" does not exist
>> LINE 1: select * from
>> grass_gis.APGB_aerial_2_i_segment_drained_peat...
>>                        ^
>> DBMI-PostgreSQL driver error:
>> select * from grass_gis.APGB_aerial_2_i_segment_drained_peat
>> _with_exposed_haggs_vct where 1 = 0
>> ERROR:  relation "grass_gis.apgb_aerial_2_i_segment_drained_
>> peat_with_exposed_haggs_vct" does not exist
>> LINE 1: select * from
>> grass_gis.APGB_aerial_2_i_segment_drained_peat...
>>                        ^
>> *ERROR: Unable to describe table*
<grass_gis.APGB_aerial_2_i_segment_drained_peat_with_exposed_haggs_vct>
>
>
> 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 ?

ore precise would be
v.db.connect -p
APGB_aerial_2_i_segment_drained_peat_with_exposed_haggs_vct at PERMANENT

because there may be a bug in v.out.postgis, not properly reading the
database connection of the input vector.

Markus Metz

>
> Moritz
>
> _______________________________________________
> grass-user mailing list
> grass-user at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/grass-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20180628/e6f7ac38/attachment.html>