Opened 7 years ago

Closed 2 years ago

Last modified 2 years ago

#2387 closed defect (worksforme)

v.in.ogr import from external PostgreSQL-server throws error if schema name and user name are identical

Reported by: hemeybo Owned by: grass-dev@…
Priority: normal Milestone: 7.6.0
Component: Database Version: svn-releasebranch70
Keywords: v.in.ogr PostgreSQL schema user name Cc:
CPU: x86-64 Platform: Linux

Description

During import with v.in.ogr from an external PostgreSQL-server, an error occurs if schema name in the PostgreSQL-DB and user name are identical: v.in.ogr dsn="PG:host=192.168.174.100 dbname=gis user=test password=" layer=test.grass_test_geom_neu_oc output=grasstest

ERROR: Layer <LAYER NAME> not available

If another schema name is used, everything is imported as it is supposed to. v.in.ogr dsn="PG:host=192.168.174.100 dbname=gis user=test password=" layer=test1.grass_test_geom_neu_oc output=grasstest

Change History (5)

comment:1 Changed 5 years ago by martinl

Milestone: 7.0.07.0.5

comment:2 Changed 5 years ago by neteler

Milestone: 7.0.57.0.6

comment:3 Changed 3 years ago by neteler

Milestone: 7.0.67.0.7

comment:4 Changed 2 years ago by martinl

Milestone: 7.0.77.6.0
Resolution: worksforme
Status: newclosed

Layer must be provided without schema name.

layer=grass_test_geom_neu_oc 

(see output of -l flag)

Last edited 2 years ago by martinl (previous) (diff)

comment:5 in reply to:  4 Changed 2 years ago by mmetz

Replying to martinl:

Layer must be provided without schema name.

layer=grass_test_geom_neu_oc 

(see output of -l flag)

No, the layer option can include schema name like layer=<schema>.<layer_name>, tested extensively with trunk and relbr76.

Note: See TracTickets for help on using tickets.