#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: | |
|---|---|---|---|
| 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 by , 8 years ago
| Milestone: | 7.0.0 → 7.0.5 |
|---|
comment:2 by , 8 years ago
| Milestone: | 7.0.5 → 7.0.6 |
|---|
comment:3 by , 6 years ago
| Milestone: | 7.0.6 → 7.0.7 |
|---|
follow-up: 5 comment:4 by , 5 years ago
| Milestone: | 7.0.7 → 7.6.0 |
|---|---|
| Resolution: | → worksforme |
| Status: | new → closed |
Version 0, edited 5 years ago by (next)
comment:5 by , 5 years ago
Replying to martinl:
Layer must be provided without schema name.
layer=grass_test_geom_neu_oc(see output of
-lflag)
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.
Layer must be provided without schema name.
` layer=grass_test_geom_neu_oc`(see output of
-lflag)