[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