Ciao ho provato ad importare uno shape in postgis ma non sono riuscito
ne con qgis ne via testuale con shp2g
luca@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