[OSM-dev] PostGIS setup returns a bunch of NOTICEs

[Peter]

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 <peter at haas-en-berg.nl>:
> 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
>