[GRASS-dev] [GRASS GIS] #3836: GRASS: db.in.ogr fails where v.in.ogr succeeds

#3836: GRASS: db.in.ogr fails where v.in.ogr succeeds
--------------------+-------------------------
Reporter: Lads | Owner: grass-dev@…
     Type: defect | Status: new
Priority: normal | Milestone:
Component: Vector | Version: unspecified
Keywords: | CPU: x86-64
Platform: Linux |
--------------------+-------------------------
This report refers to GRASS 7.6. To import a spatial table from PostGIS I
use, successfully, the following formulation with v.in.ogr:

{{{
> v.in.ogr input="PG:host=pg-server dbname=dsm user=duque004
password=secret" layer="observations.profiles" output=profiles -o
Over-riding projection check
Check if OGR layer <observations.profiles> contains polygons...
ERROR 1: Could not fetch SRS:
  100%
Creating attribute table for layer <observations.profiles>...
Importing 141584 features (OGR layer <observations.profiles>)...
  100%
-----------------------------------------------------
Building topology for vector map <profiles@test>...
Registering primitives...

}}}

But if I feed the same parameters to db.in.ogr, it fails to find the
table:

{{{
> db.in.ogr input="PG:host=pg-server dbname=dsm user=duque004
password=secret" db_table="observations.profiles" output=profiles
ERROR: Unable to open data source <observations.profiles>
ERROR: Input table <observations.profiles> not found or not
        readable
}}}

This bug report is related to the following discussions at StackExchange:

[https://gis.stackexchange.com/q/316383/21532\]

[https://gis.stackexchange.com/q/316100/21532\]

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/3836&gt;
GRASS GIS <https://grass.osgeo.org>

#3836: GRASS: db.in.ogr fails where v.in.ogr succeeds
-----------------------+-------------------------
  Reporter: Lads | Owner: grass-dev@…
      Type: defect | Status: new
  Priority: normal | Milestone: 7.6.2
Component: Database | Version: unspecified
Resolution: | Keywords: db.in.ogr
       CPU: x86-64 | Platform: Linux
-----------------------+-------------------------
Changes (by martinl):

* keywords: => db.in.ogr
* component: Vector => Database
* milestone: => 7.6.2

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/3836#comment:1&gt;
GRASS GIS <https://grass.osgeo.org>