[GRASS-user] v.external and POSTGIS

[Gustavo Martínez]

Hello Stephan,


I've already verified that and v.in.ogr lists PostgreSQL as one of the  
available formats and also the command you suggested.

Gustavo

En Thu, 15 Feb 2007 12:40:42 -0300, Stephan Holl  
<stephan.holl at intevation.de> escribió:

> Hello Gustavo,
>
> Gustavo Martínez <gumartin at mecon.gov.ar>, [20070215 - 12:11:13]
>
>> Hello all,
>>
>> I'm starting with POSTGIS and GRASS and I have some problems with
>> v.external.
>> My computer is running Debian 'testing' AMD64 with GRASS 6.2.0,
>> Postgresql 8.1 and Postgis 1.1.6, all from debian packages.
>> On Postgres, I have a table named vms with column geometry storing
>> POINTS. If I connect from GRASS to the database the connection is
>> successful:
>>
>> db.tables driver=pg database=host=localhost,dbname=pesca
>> 	public.geometry_columns
>> 	public.spatial_ref_sys
>> 	public.vms
>>
>> When I use v.external:
>>
>> v.external dsn='PG:host=localhost user=gumartin dbname=pesca'
>> output=pp layer=vms
>>
>> 	Cannot open data source
>>
>> Can anybody help me with this? What am I doing wrong?
>
>
> This are 2 pairs of shoes. db.tables uses GRASS pg-driver while
> v.external uses the OGR-based postgresql-driver.
>
> So it seems that you build grass with postgresql-support, but not your
> underlaying gdal/ogr-library?!
>
> You could check if your ogr is linked against postgresql by typing
> ogrinfo --formats|grep -i postgres
>
> HTH
>
> 	Stephan
>
>



-- 
Lic. Gustavo Martínez
Sub Secretaría de Pesca de la Nación
Paseo Colón 922 Of. 329
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.”