[GRASS-user] problem with v.out.ogr & pgsql

[Micha Silver]

On 03/31/2010 09:31 AM, Markus Neteler wrote:
> On Wed, Mar 31, 2010 at 1:21 AM, Giovanni Manghi
> <giovanni.manghi at gmail.com>  wrote:
>    
>> Hi all,
>> I'm trying to export a polygon from GRASS to postgis and the command I'm
>> using is like this
>>
>>
>> v.out.ogr -c input=polygon at mapset type=area dsn=PG:host=localhost
>> dbname=postgis user=users password=users format=PostgreSQL
>>
>>
>> but I always get
>>
>>
>> ERROR 1: AddGeometryColumn failed for layer
>> polygon at mapset, layer creation has failed.
>> ERROR: Unable to create OGR layer
>>
>>
>> The database is spatially enabled and the user has the right permissions
>> to write in it.
>>      
> Does export to SHP file work (v.out.ogr) and upload to PostGIS
> (shp2pgsql)? Really all permissions ok?
>    
In particular, check permissions on the geometry_columns table. In psql 
type:
\dp geometry_columns;

> Markus
> _______________________________________________
> grass-user mailing list
> grass-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/grass-user
>
> This mail was received via Mail-SeCure System.
>
>
>    


-- 
Micha Silver
http://www.surfaces.co.il/
Arava Development Co.  +972-52-3665918