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

GRASS GRASS user
,
1

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@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@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.

Didn't had much more success with v.out.ogr.pg.py has the error message
is the same.

Any hint?

thanks in advance

-- Giovanni --

2

On Wed, Mar 31, 2010 at 1:21 AM, Giovanni Manghi
<giovanni.manghi@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@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@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?

Markus

3

Sometimes GUI output is not like commandline commands have to be. Maybe its just the missing " ".

?

v.out.ogr -c input=polygon@mapset type=area dsn=PG:host=localhost
dbname=postgis user=users password=users format=PostgreSQL

v.out.ogr -c input=polygon@mapset type=area dsn="PG:host=localhost"
dbname=postgis user=users password=users format=PostgreSQL

4

Hi Markus,
thanks for the reply

Does export to SHP file work (v.out.ogr) and upload to PostGIS
(shp2pgsql)? Really all permissions ok?

it seems all ok.

v.out.ogr works for shapes, and I can upload to postgis with the same
user to the same database with shp2pgsql or with other clients that use
it (qgis).

cheers

-- Giovanni --

5

On 03/31/2010 09:31 AM, Markus Neteler wrote:

On Wed, Mar 31, 2010 at 1:21 AM, Giovanni Manghi
<giovanni.manghi@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@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@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@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

6

Hi,
  

In particular, check permissions on the geometry_columns table. In psql
type:
\dp geometry_columns;

it is ok,
it has been given a "GRANT ALL"

cheers

-- Giovanni --

7

Hi,

I tested from the command line with the " ", and from the wx gui (that
apparently does not add the " ") and the result is the same.

Cheers

-- Giovanni --

On Wed, 2010-03-31 at 09:19 +0200, Achim Kisseler wrote:

Sometimes GUI output is not like commandline commands have to be. Maybe
its just the missing " ".

?

>
> v.out.ogr -c input=polygon@mapset type=area dsn=PG:host=localhost
> dbname=postgis user=users password=users format=PostgreSQL
>
>

v.out.ogr -c input=polygon@mapset type=area dsn="PG:host=localhost"
dbname=postgis user=users password=users format=PostgreSQL
_______________________________________________
grass-user mailing list
grass-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-user