[GRASS-user] error in v.select

Pankaj Kr Sharma pkscwc at gmail.com
Sat Dec 3 11:20:31 EST 2011


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 at PERMANENT alayer=1 atype=point
binput=yb123450str_start_temp2 at 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 at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/grass-user/attachments/20111203/7f2a5263/attachment.html


More information about the grass-user mailing list