[Gfoss] Aiuto postgres-postgis

[Pietro]

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