[Gfoss] Aiuto postgres-postgis
Alessio Di Lorenzo
alessio.dilorenzo a gmail.com
Ven 30 Nov 2007 22:33:29 CET
Ciao Pietro,
tempo fa ho scritto una pagina wiki (UbuntuGIS) su ubuntu-it.org
Due o tre giorni fa ho aggiornato le istruzioni per renderle adatte a Gutsy:
http://wiki.ubuntu-it.org/UbuntuGis
prova a seguirla, è molto semplice...
ciao
Alessio
Pietro ha scritto:
> Niente,
> loggato come postgres e dato il comando che mi avete indicato (ora
> trovate pippodue come db, perchè ho anche provato a fare un dropdb e a
> crearne un altro, pippodue appunto)
>
> pieri a pieri-laptop:~$ su postgres
> Parola d'ordine:
> postgres a pieri-laptop:/home/pieri$ psql -U postgres -d pippodueWelcome
> to psql 8.2.5, the PostgreSQL interactive terminal.
>
> Type: \copyright for distribution terms
> \h for help with SQL commands
> \? for help with psql commands
> \g or terminate with semicolon to execute query
> \q to quit
>
> pippodue=# create language plpgsql
> pippodue-#
>
>
> Questo è il nuovo output:
>
> postgres a pieri-laptop:/home/pieri/provapgis/prova$ psql -d pippodue -f
> /usr/share/postgresql-8.2-postgis/lwpostgis.sql
> BEGIN
> psql:/usr/share/postgresql-8.2-postgis/lwpostgis.sql:43: NOTICE: type
> "histogram2d" is not yet defined
> DETAIL: Creating a shell type definition.
> CREATE FUNCTION
> psql:/usr/share/postgresql-8.2-postgis/lwpostgis.sql:48: NOTICE:
> argument type histogram2d is only a shell
> CREATE FUNCTION
> CREATE TYPE
> psql:/usr/share/postgresql-8.2-postgis/lwpostgis.sql:73: NOTICE: type
> "spheroid" is not yet defined
> DETAIL: Creating a shell type definition.
> CREATE FUNCTION
> psql:/usr/share/postgresql-8.2-postgis/lwpostgis.sql:78: NOTICE:
> argument type spheroid is only a shell
> CREATE FUNCTION
> CREATE TYPE
> psql:/usr/share/postgresql-8.2-postgis/lwpostgis.sql:102: NOTICE: type
> "geometry" is not yet defined
> DETAIL: Creating a shell type definition.
> CREATE FUNCTION
> psql:/usr/share/postgresql-8.2-postgis/lwpostgis.sql:107: NOTICE:
> argument type geometry is only a shell
> CREATE FUNCTION
> CREATE FUNCTION
> psql:/usr/share/postgresql-8.2-postgis/lwpostgis.sql:120: NOTICE:
> return type geometry is only a shell
> CREATE FUNCTION
> psql:/usr/share/postgresql-8.2-postgis/lwpostgis.sql:125: NOTICE:
> argument type geometry is only a shell
> CREATE FUNCTION
> CREATE TYPE
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> psql:/usr/share/postgresql-8.2-postgis/lwpostgis.sql:236: NOTICE: type
> "box3d" is not yet defined
> DETAIL: Creating a shell type definition.
> CREATE FUNCTION
> psql:/usr/share/postgresql-8.2-postgis/lwpostgis.sql:241: NOTICE:
> argument type box3d is only a shell
> CREATE FUNCTION
> CREATE TYPE
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> psql:/usr/share/postgresql-8.2-postgis/lwpostgis.sql:295: NOTICE: type
> "chip" is not yet defined
> DETAIL: Creating a shell type definition.
> CREATE FUNCTION
> psql:/usr/share/postgresql-8.2-postgis/lwpostgis.sql:300: NOTICE:
> argument type chip is only a shell
> CREATE FUNCTION
> CREATE TYPE
> psql:/usr/share/postgresql-8.2-postgis/lwpostgis.sql:326: NOTICE: type
> "box2d" is not yet defined
> DETAIL: Creating a shell type definition.
> CREATE FUNCTION
> psql:/usr/share/postgresql-8.2-postgis/lwpostgis.sql:331: NOTICE:
> argument type box2d is only a shell
> CREATE FUNCTION
> CREATE TYPE
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> ************
> snip
> ****************
> CREATE AGGREGATE
> CREATE FUNCTION
> CREATE FUNCTION
> psql:/usr/share/postgresql-8.2-postgis/lwpostgis.sql:1261: ERROR: il
> linguaggio "plpgsql" non esiste
> HINT: Use CREATE LANGUAGE to load the language into the database.
> psql:/usr/share/postgresql-8.2-postgis/lwpostgis.sql:1269: ERROR:
> current transaction is aborted, commands ignored until end of
> transaction block
> psql:/usr/share/postgresql-8.2-postgis/lwpostgis.sql:1277: ERROR:
> current transaction is aborted, commands ignored until end of
> transaction block
>
> e avanti..
>
> Che può essere?
>
> plpgsql è un linguaggio procedurale?
> (http://www.postgresql.org/docs/8.2/static/xplang-install.html)
>
> Grazie di nuovo
> riciao
> p
>
> _______________________________________________
> Iscriviti all'associazione GFOSS.it: http://www.gfoss.it/drupal/iscrizione
> Gfoss a faunalia.com
> http://www.faunalia.com/cgi-bin/mailman/listinfo/gfoss
> 281 iscritti al 26.11.2007
> Questa e' una lista di discussione pubblica aperta a tutti.
> I messaggi di questa lista non rispecchiano necessariamente
> le posizioni dell'Associazione GFOSS.it.
>
>
Maggiori informazioni sulla lista
Gfoss