Dear list and developers,
In GRASS7, v.select module is not creating the postgres table in a schema situation.
The “schema situation” means, vector tables are in schema other than public.
I have seen this happening on two machines. In default public schema, it’s working properly.
The output of v.select is posted below;
v.select --verbose ainput=yb123450str@PERMANENT alayer=1 atype=point binput=yb123450str_start_temp2@PERMANENT blayer=1 btype=point output=yb123450_starts operator=equals
Processing features…
Writing selected features…
Writing attributes…
DBMI-Postgres driver error:
Cannot create table:
create table
gis_schema.yb123450_starts_gis_schema.yb123450str ( cat
integer, stream_type varchar(20), type_code integer,
basin_area integer )
ERROR: cross-database references are not implemented:
“gis_schema.yb123450_starts_gis_schema.yb123450str”
Unable to create table <gis_schema.yb123450_starts_gis_schema.yb123450str>
Unable to copy table for layer 1
DBMI-Postgres driver error:
Cannot create table:
create table
gis_schema.yb123450_starts_gis_schema.yb123450str_2 ( cat
integer, point_cat integer, type_cat integer )
ERROR: cross-database references are not implemented:
“gis_schema.yb123450_starts_gis_schema.yb123450str_2”
Unable to create table <gis_schema.yb123450_starts_gis_schema.yb123450str_2>
Unable to copy table for layer 2
Building topology for vector map yb123450_starts@PERMANENT…
Registering primitives…
96 primitives registered
96 vertices registered
Building areas…
0 areas built
0 isles built
Attaching islands…
Attaching centroids…
Topology was built
Number of nodes: 0
Number of primitives: 96
Number of points: 96
Number of lines: 0
Number of boundaries: 0
Number of centroids: 0
Number of areas: 0
Number of isles: 0
v.select complete. 96 features written to output.
(Sat Dec 3 21:39:54 2011) Command finished (0 sec)
Hope it helps.