[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