[Gfoss] non riesco a importare uno shape in postgis

Luca Delucchi lucadeluge at gmail.com
Sun Jul 8 01:19:30 CEST 2007


Ciao ho provato ad importare uno shape in postgis ma non sono riuscito
ne con qgis ne via testuale con shp2g

luca a luca-desktop:~$ psql -h localhost -U luca -d datageo -f
/home/luca/Desktop/impianti.sql
Password for user luca:
BEGIN
psql:/home/luca/Desktop/impianti.sql:4: NOTICE:  CREATE TABLE will
create implicit sequence "impianti_gid_seq" for serial column
"impianti.gid"
psql:/home/luca/Desktop/impianti.sql:4: NOTICE:  CREATE TABLE /
PRIMARY KEY will create implicit index "impianti_pkey" for table
"impianti"
CREATE TABLE
psql:/home/luca/Desktop/impianti.sql:5: ERROR:  permesso negato per la
relazione geometry_columns
CONTEXT:  SQL statement "DELETE FROM geometry_columns WHERE
                f_table_catalog = '' AND f_table_schema = 'public' AND
f_table_name = 'impianti' AND f_geometry_column = 'the_geom'"
PL/pgSQL function "addgeometrycolumn" line 80 at execute statement
SQL statement "SELECT  AddGeometryColumn('', $1 , $2 , $3 , $4 , $5 , $6 )"
PL/pgSQL function "addgeometrycolumn" line 4 at select into variables
psql:/home/luca/Desktop/impianti.sql:6: ERROR:  current transaction is
aborted, commands ignored until end of transaction block
psql:/home/luca/Desktop/impianti.sql:7: ERROR:  current transaction is
aborted, commands ignored until end of transaction block
psql:/home/luca/Desktop/impianti.sql:8: ERROR:  current transaction is
aborted, commands ignored until end of transaction block
psql:/home/luca/Desktop/impianti.sql:9: ERROR:  current transaction is
aborted, commands ignored until end of transaction block
psql:/home/luca/Desktop/impianti.sql:10: ERROR:  current transaction
is aborted, commands ignored until end of transaction block
psql:/home/luca/Desktop/impianti.sql:11: ERROR:  current transaction
is aborted, commands ignored until end of transaction block
psql:/home/luca/Desktop/impianti.sql:12: ERROR:  current transaction
is aborted, commands ignored until end of transaction block
psql:/home/luca/Desktop/impianti.sql:13: ERROR:  current transaction
is aborted, commands ignored until end of transaction block
psql:/home/luca/Desktop/impianti.sql:14: ERROR:  current transaction
is aborted, commands ignored until end of transaction block
ROLLBACK

mentre in qgis mi ha dato un problema di permessi...

grazie luca



More information about the Gfoss mailing list