[GRASS-user] v.out.postgis

[Moritz Lennert]

On 29/06/18 10:39, Paul Shapley wrote:
> Hi Markus,
> 
> OK here is the result of v.db.connect -p
> 
> v.db.connect -p 
> APGB_aerial_2_i_segment_drained_peat_with_exposed_haggs_vector
> Vector map 
> <APGB_aerial_2_i_segment_drained_peat_with_exposed_haggs_vector> is 
> connected by:
> 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>

So it's PostgreSQL as attribute database backend.

What is the output of

v.db.select APGB_aerial_2_i_segment_drained_peat_with_exposed_haggs_vector

?

Moritz

> 
> 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).
> 
> Thanks,
> 
> Paul Shapley
> 
> On 28 June 2018 at 13:22, Markus Metz <markus.metz.giswork at gmail.com 
> <mailto:markus.metz.giswork at gmail.com>> wrote:
> 
> 
> 
>     On Thu, Jun 28, 2018 at 1:40 PM, Moritz Lennert
>     <mlennert at club.worldonline.be <mailto: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 <mailto:grass-user at lists.osgeo.org>
>      > https://lists.osgeo.org/mailman/listinfo/grass-user
>     <https://lists.osgeo.org/mailman/listinfo/grass-user>
> 
> 
> 
> 
> -- 
> *Paul J. Shapley *MSc CGeog (GIS) FRGS
> *
> *
> 
> 
> _______________________________________________
> grass-user mailing list
> grass-user at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/grass-user
>