[Gfoss] Aiuto postgres-postgis

Pietro Rossin pietrat a hotmail.com
Ven 30 Nov 2007 18:33:58 CET


Fatto!
non mi sono loggato nel db, ma l'ho fatto come utente postgres 
all'esterno del db

postgres a pieri-laptop:/home/pieri$ createlang plpgsql pippodue
postgres a pieri-laptop:/home/pieri$

postgres a pieri-laptop:/home/pieri$ psql -d pippodue -f 
/usr/share/postgresql-8.2-postgis/lwpostgis.sql


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

************************
snip
***********************

CREATE FUNCTION
CREATE FUNCTION
psql:/usr/share/postgresql-8.2-postgis/lwpostgis.sql:1339: NOTICE:  
CREATE TABLE / PRIMARY KEY will create implicit index 
"spatial_ref_sys_pkey" for table "spatial_ref_sys"
CREATE TABLE
psql:/usr/share/postgresql-8.2-postgis/lwpostgis.sql:1357: NOTICE:  
CREATE TABLE / PRIMARY KEY will create implicit index 
"geometry_columns_pk" for table "geometry_columns"
CREATE TABLE
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION

**********************
snip
*********************

CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
COMMIT



Ora dovrei riuscire a loggarmi con qgis al db?

Provo...
ciao
p



Maggiori informazioni sulla lista Gfoss