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