I already have my answer. http://postgis.refractions.net/pipermail/postgis-users/2006-November/013995.html I can safely ignore these messages.
2010/12/22 Peter <[email protected]>: > 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 > _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
