El Monday 29 October 2007 10:33:40 escribió: > On 25/10/07 17:20, Gustavo Martinez wrote: > > Hi all, > > > > I am using GRASS 6.3 RC1 compiled from source. I have a big table (2 > > million points) in Postgresql/Postgis that I can map with v.external. The > > problem is when I try to select a subset of the data. I am using gis.m > > and when I run the command: > > > > > > d.vect [EMAIL PROTECTED] color=0:0:0 lcolor=0:0:0 > > fcolor=170:170:170 display=shape type=point icon=basic/circle size=5 > > layer=1 lsize=8 xref=left yref=center llayer=1 {where=vel<4} > > > > I get the following error: > > > > ERROR 1: ERROR: error de sintaxis en o cerca de «FROM» > > LINE 1: SELECT FROM monitoreo WHERE vel<4 > > ^ > > > > DBMI-OGR driver error: > > Cannot select: > > SELECT FROM monitoreo WHERE vel<4 > > > > Any clues? > > What does v.db.connect -p monitoreo show ? > Does database access work for v.external maps just as it does for > imported maps ? > > Moritz
Moritz, the result of v.db.connect monitoreo -p is: Vector map <monitoreo> is connected by: layer <1> table <monitoreo> in database <PG:host=localhost dbname=pesca-new user=postgres> through driver <ogr> with key <> Gustavo -- Lic. Gustavo Martínez Gestión de Pesquerías Sub Secretaría de Pesca de la Nación Paseo Colón 982, Anexo Jardín Pesca Tel: (54) 11 43492165 Buenos Aires, República Argentina “Que la tierra se vaya haciendo camino ante tus pasos, que el viento sople siempre a tus espaldas, que el sol brille cálido sobre tu cara, que la lluvia caiga suavemente sobre tus campos y, hasta tanto volvamos a encontrarnos, que Dios te lleve en la palma de su mano.” _______________________________________________ grassuser mailing list grassuser@grass.itc.it http://grass.itc.it/mailman/listinfo/grassuser