Opened 13 years ago
Closed 6 years ago
#1481 closed defect (worksforme)
v.in.ogr with postgis layers fails if the table schema is on the first place in the search_path of the database
Reported by: | tomdb | Owned by: | |
---|---|---|---|
Priority: | normal | Milestone: | 7.0.7 |
Component: | Vector | Version: | 6.4.1 |
Keywords: | v.in.ogr, postgis | Cc: | tomdb |
CPU: | x86-32 | Platform: | Linux |
Description
The command
v.in.ogr dsn="PG:dbname=XXX user=XXX host=XXX" layer=venue.stand_lines output=lines type=boundary
fails if the schema "venue" is on the first place of the search path of the database XXX. The same command without the schema definition ( "layer=stand_lines") works fine as expected. Examples:
XXX=>ALTER DATABASE XXX set search_path = venue,public; GRASS 6.4.1 (xy):~/grassdata/xy >v.in.ogr dsn="PG:dbname=XXX user=XXX host=localhost " layer=venue.stand_lines output=lines type=boundary --overwrite WARNING: Vector map <lines> already exists and will be overwritten ERROR: Layer <venue.stand_lines> not available
XXX=>ALTER DATABASE XXX set search_path = venue,public; GRASS 6.4.1 (xy):~/grassdata/xy >v.in.ogr dsn="PG:dbname=XXX user=XXX host=localhost " layer=stand_lines output=lines type=boundary --overwrite ...works fine....
XXX=>ALTER DATABASE XXX set search_path = public,venue; GRASS 6.4.1 (xy):~/grassdata/xy > v.in.ogr dsn="PG:dbname=XXX user=XXX host=localhost " layer=venue.stand_lines output=lines type=boundary --overwrite ...works fine....
XXX=>ALTER DATABASE XXX set search_path = venue,public; GRASS 6.4.1 (xy):~/grassdata/xy > v.in.ogr dsn="PG:dbname=XXX user=XXX host=localhost " layer=stand_lines output=lines type=boundary --overwrite ...works fine....
XXX=>ALTER DATABASE XXX set search_path = public; GRASS 6.4.1 (xy):~/grassdata/xy > v.in.ogr dsn="PG:dbname=XXX user=XXX host=localhost " layer=venue.stand_lines output=lines type=boundary --overwrite ...works fine....
Change History (7)
comment:1 by , 13 years ago
comment:2 by , 10 years ago
CPU: | Unspecified → x86-32 |
---|---|
Keywords: | v.in.ogr postgis added |
Problem still present on Grass 7.0, PostgreSQL 9.3
comment:3 by , 10 years ago
Cc: | added |
---|---|
Milestone: | → 7.0.0 |
comment:4 by , 9 years ago
Milestone: | 7.0.0 → 7.0.5 |
---|
comment:5 by , 8 years ago
Milestone: | 7.0.5 → 7.0.6 |
---|
comment:6 by , 7 years ago
Milestone: | 7.0.6 → 7.0.7 |
---|
Note:
See TracTickets
for help on using tickets.
Postgres version: