[OSM-dev] PostGIS setup returns a bunch of NOTICEs
Peter
peter at haas-en-berg.nl
Wed Dec 22 18:46:37 GMT 2010
Hi all!
I'm writing a tileserver install script.
The part of this script that is supposed to setup the db looks like this:
sudo -u postgres createuser -s gis
sudo -u postgres createdb -E UTF8 -O gis gis
sudo -u postgres createlang plpgsql gis >> /var/log/script.log
sudo -u postgres psql -qd gis -f /usr/share/postgresql/8.4/contrib/postgis.sql
sudo -u postgres psql -qd gis -f
/usr/share/postgresql/8.4/contrib/spatial_ref_sys.sql
sudo -u postgres psql -qd gis -c "ALTER TABLE geometry_columns OWNER
TO gis; ALTER TABLE spatial_ref_sys OWNER TO gis;"
sudo -u postgres psql -qd gis -f /usr/share/postgresql/8.4/contrib/_int.sql
The output of this part of the script:
psql:/usr/share/postgresql/8.4/contrib/postgis.sql:53: NOTICE: type
"spheroid" is not yet defined
DETAIL: Creating a shell type definition.
psql:/usr/share/postgresql/8.4/contrib/postgis.sql:59: NOTICE: return
type spheroid is only a shell
psql:/usr/share/postgresql/8.4/contrib/postgis.sql:65: NOTICE:
argument type spheroid is only a shell
psql:/usr/share/postgresql/8.4/contrib/postgis.sql:71: NOTICE:
argument type spheroid is only a shell
psql:/usr/share/postgresql/8.4/contrib/postgis.sql:88: NOTICE: type
"geometry" is not yet defined
DETAIL: Creating a shell type definition.
psql:/usr/share/postgresql/8.4/contrib/postgis.sql:94: NOTICE: return
type geometry is only a shell
psql:/usr/share/postgresql/8.4/contrib/postgis.sql:100: NOTICE:
argument type geometry is only a shell
psql:/usr/share/postgresql/8.4/contrib/postgis.sql:106: NOTICE:
argument type geometry is only a shell
psql:/usr/share/postgresql/8.4/contrib/postgis.sql:124: NOTICE:
return type geometry is only a shell
psql:/usr/share/postgresql/8.4/contrib/postgis.sql:130: NOTICE:
return type geometry is only a shell
psql:/usr/share/postgresql/8.4/contrib/postgis.sql:136: NOTICE:
argument type geometry is only a shell
psql:/usr/share/postgresql/8.4/contrib/postgis.sql:142: NOTICE:
argument type geometry is only a shell
psql:/usr/share/postgresql/8.4/contrib/postgis.sql:323: NOTICE: type
"box3d" is not yet defined
DETAIL: Creating a shell type definition.
psql:/usr/share/postgresql/8.4/contrib/postgis.sql:329: NOTICE:
argument type box3d is only a shell
psql:/usr/share/postgresql/8.4/contrib/postgis.sql:335: NOTICE:
return type box3d is only a shell
psql:/usr/share/postgresql/8.4/contrib/postgis.sql:341: NOTICE:
argument type box3d is only a shell
psql:/usr/share/postgresql/8.4/contrib/postgis.sql:356: NOTICE: type
"box3d_extent" is not yet defined
DETAIL: Creating a shell type definition.
psql:/usr/share/postgresql/8.4/contrib/postgis.sql:361: NOTICE:
argument type box3d_extent is only a shell
psql:/usr/share/postgresql/8.4/contrib/postgis.sql:379: NOTICE: type
"box2d" is not yet defined
DETAIL: Creating a shell type definition.
psql:/usr/share/postgresql/8.4/contrib/postgis.sql:467: NOTICE: type
"chip" is not yet defined
DETAIL: Creating a shell type definition.
psql:/usr/share/postgresql/8.4/contrib/postgis.sql:473: NOTICE:
return type chip is only a shell
psql:/usr/share/postgresql/8.4/contrib/postgis.sql:479: NOTICE:
argument type chip is only a shell
psql:/usr/share/postgresql/8.4/contrib/postgis.sql:485: NOTICE:
argument type chip is only a shell
psql:/usr/share/postgresql/8.4/contrib/postgis.sql:503: NOTICE:
return type box2d is only a shell
psql:/usr/share/postgresql/8.4/contrib/postgis.sql:509: NOTICE:
return type box2d is only a shell
psql:/usr/share/postgresql/8.4/contrib/postgis.sql:515: NOTICE:
argument type box2d is only a shell
psql:/usr/share/postgresql/8.4/contrib/postgis.sql:521: NOTICE:
argument type box2d is only a shell
psql:/usr/share/postgresql/8.4/contrib/postgis.sql:2236: NOTICE:
CREATE TABLE / PRIMARY KEY will create implicit index
"spatial_ref_sys_pkey" for table "spatial_ref_sys"
psql:/usr/share/postgresql/8.4/contrib/postgis.sql:2254: NOTICE:
CREATE TABLE / PRIMARY KEY will create implicit index
"geometry_columns_pk" for table "geometry_columns"
psql:/usr/share/postgresql/8.4/contrib/postgis.sql:4078: NOTICE: type
"pgis_abs" is not yet defined
DETAIL: Creating a shell type definition.
psql:/usr/share/postgresql/8.4/contrib/postgis.sql:4083: NOTICE:
argument type pgis_abs is only a shell
psql:/usr/share/postgresql/8.4/contrib/_int.sql:14: NOTICE: type
"query_int" is not yet defined
DETAIL: Creating a shell type definition.
psql:/usr/share/postgresql/8.4/contrib/_int.sql:19: NOTICE: argument
type query_int is only a shell
psql:/usr/share/postgresql/8.4/contrib/_int.sql:390: NOTICE: type
"intbig_gkey" is not yet defined
DETAIL: Creating a shell type definition.
psql:/usr/share/postgresql/8.4/contrib/_int.sql:395: NOTICE: argument
type intbig_gkey is only a shell
Should I be worried? Or is this ok?
Peter
More information about the dev
mailing list