[postgis-users] Install PostGIS 0.8.1...postgis.sql ???

Fri Feb 27 18:09:37 PST 2004

Hello Greg.
OK.
Thank you very much

Carlos FG
Know the Metropolitan Area of São Paulo-Brazil:
http://www.mapas.centrodametropole.org.br/servidormapas/html/index.html

>
> Yes, it finished ok.
>
> You may need to load the spatial_references table (the
> "spatial_ref_sys.sql" script) depending on what you need to do. Your
> db_test database has the GIS functions and types, etc. loaded.
>
> You can see this by running your psql tool:
>
> gex_runtime=# select postgis_version();
>             postgis_version
> ---------------------------------------
>  0.8 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
> (1 row)
>
>
> Greg W.
>
> -----Original Message-----
> From:	Carlos Fernando Gonçalves [mailto:cgoncalves at visionweb.com.br]
> Sent:	Fri 2/27/2004 5:49 PM
> To:	postgis-users at postgis.refractions.net
> Cc:
> Subject:	RE: [postgis-users] Install PostGIS 0.8.1...postgis.sql ???
> Hello Greg.
> If I understood well there is no problem.
> Was the installation completed with success?
> At once I thank his attention.
>
> Carlos FG
>
>
>>
>> Seems quite similar to what I've seen ... the warnings are just that
>> -- warnings. The final "COMMIT" is the tipoff that all went well.
>>
>> Have fun!
>>
>> Greg Williamson
>> DBA
>> GlobeXplorer LLC
>>
>> -----Original Message-----
>> From:	Carlos Fernando Gonçalves [mailto:cgoncalves at visionweb.com.br]
>> Sent:	Fri 2/27/2004 5:31 PM
>> To:	postgis-users at postgis.refractions.net
>> Cc:
>> Subject:	[postgis-users] Install PostGIS 0.8.1...postgis.sql ??? Hello
>> to all.
>> I am using in my project Linux Red Hat 9, PostgreSQL 7.4.1 (with code
>> source in tree).
>> I am making the installation of the version of PostGIS 0.8.1.
>> The code source where is located the directory of PostGIS is:
>>
>> /usr/local/src/postgresql-7.4.1/contrib/postgis-0.8.1
>>
>> In the file Makefiledo PostGIS, I am with the parameters
>> USE_PROJ=0,USE_GEOS=0 and USE_STATS=0.
>> I usually execute,
>> make
>> make install
>> su – postgres
>> createdb db_test
>> createlang plpgsql db_test
>> OK.
>> I would like to know if it is norm in the moment of execution || psql
>> - d db_test - f postgis.sql || to appear these messages:
>>
>>
>> BEGIN
>>         message
>> ------------------------
>>  PL/PgSQL is installed.
>> (1 row)
>>
>> psql:/usr/local/src/postgresql-7.4.1/contrib/postgis-0.8.1/postgis.sql:44:
>> NOTICE:  type "histogram2d"
>> is not yet defined
>> DETAIL:  Creating a shell type definition.
>> CREATE FUNCTION
>> psql:/usr/local/src/postgresql-7.4.1/contrib/postgis-0.8.1/postgis.sql:49:
>> NOTICE:  argument type histogram2d is only a shell
>> CREATE FUNCTION
>> CREATE TYPE
>> psql:/usr/local/src/postgresql-7.4.1/contrib/postgis-0.8.1/postgis.sql:65:
>> NOTICE:  type "box3d" is not yet defined
>> DETAIL:  Creating a shell type definition.
>> CREATE FUNCTION
>> psql:/usr/local/src/postgresql-7.4.1/contrib/postgis-0.8.1/postgis.sql:70:
>> NOTICE:  argument type box3d is only a shell
>> CREATE FUNCTION
>> CREATE TYPE
>> psql:/usr/local/src/postgresql-7.4.1/contrib/postgis-0.8.1/postgis.sql:85:
>> NOTICE:  type "spheroid" is
>> not yet defined
>> DETAIL:  Creating a shell type definition.
>> CREATE FUNCTION
>> psql:/usr/local/src/postgresql-7.4.1/contrib/postgis-0.8.1/postgis.sql:90:
>> NOTICE:  argument type spheroid is only a shell
>> CREATE FUNCTION
>> CREATE TYPE
>> psql:/usr/local/src/postgresql-7.4.1/contrib/postgis-0.8.1/postgis.sql:105:
>> NOTICE:  type "wkb" is not
>> yet defined
>> DETAIL:  Creating a shell type definition.
>> CREATE FUNCTION
>> psql:/usr/local/src/postgresql-7.4.1/contrib/postgis-0.8.1/postgis.sql:110:
>> NOTICE:  argument type wkb
>> is only a shell
>> CREATE FUNCTION
>> psql:/usr/local/src/postgresql-7.4.1/contrib/postgis-0.8.1/postgis.sql:115:
>> NOTICE:  return type wkb is only a shell
>> CREATE FUNCTION
>> psql:/usr/local/src/postgresql-7.4.1/contrib/postgis-0.8.1/postgis.sql:124:
>> NOTICE:  type "chip" is not yet defined
>> DETAIL:  Creating a shell type definition.
>> CREATE FUNCTION
>> psql:/usr/local/src/postgresql-7.4.1/contrib/postgis-0.8.1/postgis.sql:129:
>> NOTICE:  argument type chip is only a shell
>> CREATE FUNCTION
>> CREATE TYPE
>> psql:/usr/local/src/postgresql-7.4.1/contrib/postgis-0.8.1/postgis.sql:145:
>> NOTICE:  type "geometry" is not yet defined
>> DETAIL:  Creating a shell type definition.
>> CREATE FUNCTION
>> psql:/usr/local/src/postgresql-7.4.1/contrib/postgis-0.8.1/postgis.sql:150:
>> NOTICE:  argument type geometry is only a shell
>> CREATE FUNCTION
>> CREATE TYPE
>> CREATE FUNCTION
>> psql:/usr/local/src/postgresql-7.4.1/contrib/postgis-0.8.1/postgis.sql:260:
>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>> "spatial_ref_sys_pkey" for table "spatial_ref_sys"
>> CREATE TABLE
>> psql:/usr/local/src/postgresql-7.4.1/contrib/postgis-0.8.1/postgis.sql:280:
>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>> "geometry_columns_pk" for table "geometry_columns"
>> CREATE TABLE
>> UPDATE 1
>> UPDATE 1
>> UPDATE 1
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> 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/local/src/postgresql-7.4.1/contrib/postgis-0.8.1/postgis.sql:473:
>> NOTICE:  return type wkb is only a shell
>> CREATE FUNCTION
>> psql:/usr/local/src/postgresql-7.4.1/contrib/postgis-0.8.1/postgis.sql:478:
>> NOTICE:  return type wkb is only a shell
>> CREATE FUNCTION
>> psql:/usr/local/src/postgresql-7.4.1/contrib/postgis-0.8.1/postgis.sql:483:
>> NOTICE:  argument type wkb
>> is only a shell
>> CREATE FUNCTION
>> psql:/usr/local/src/postgresql-7.4.1/contrib/postgis-0.8.1/postgis.sql:488:
>> NOTICE:  argument type wkb
>> is only a shell
>> CREATE FUNCTION
>> psql:/usr/local/src/postgresql-7.4.1/contrib/postgis-0.8.1/postgis.sql:493:
>> NOTICE:  argument type wkb
>> is only a shell
>> CREATE FUNCTION
>> psql:/usr/local/src/postgresql-7.4.1/contrib/postgis-0.8.1/postgis.sql:498:
>> NOTICE:  argument type wkb
>> is only a shell
>> CREATE FUNCTION
>> psql:/usr/local/src/postgresql-7.4.1/contrib/postgis-0.8.1/postgis.sql:503:
>> NOTICE:  argument type wkb
>> is only a shell
>> CREATE FUNCTION
>> psql:/usr/local/src/postgresql-7.4.1/contrib/postgis-0.8.1/postgis.sql:508:
>> NOTICE:  argument type wkb
>> is only a shell
>> CREATE FUNCTION
>> psql:/usr/local/src/postgresql-7.4.1/contrib/postgis-0.8.1/postgis.sql:513:
>> NOTICE:  argument type wkb
>> is only a shell
>> CREATE FUNCTION
>> psql:/usr/local/src/postgresql-7.4.1/contrib/postgis-0.8.1/postgis.sql:518:
>> NOTICE:  argument type wkb
>> is only a shell
>> CREATE FUNCTION
>> psql:/usr/local/src/postgresql-7.4.1/contrib/postgis-0.8.1/postgis.sql:524:
>> NOTICE:  argument type wkb
>> is only a shell
>> CREATE FUNCTION
>> psql:/usr/local/src/postgresql-7.4.1/contrib/postgis-0.8.1/postgis.sql:529:
>> NOTICE:  argument type wkb
>> is only a shell
>> CREATE FUNCTION
>> psql:/usr/local/src/postgresql-7.4.1/contrib/postgis-0.8.1/postgis.sql:534:
>> NOTICE:  argument type wkb
>> is only a shell
>> CREATE FUNCTION
>> psql:/usr/local/src/postgresql-7.4.1/contrib/postgis-0.8.1/postgis.sql:539:
>> NOTICE:  argument type wkb
>> is only a shell
>> CREATE FUNCTION
>> psql:/usr/local/src/postgresql-7.4.1/contrib/postgis-0.8.1/postgis.sql:544:
>> NOTICE:  argument type wkb
>> is only a shell
>> CREATE FUNCTION
>> psql:/usr/local/src/postgresql-7.4.1/contrib/postgis-0.8.1/postgis.sql:549:
>> NOTICE:  argument type wkb
>> is only a shell
>> CREATE FUNCTION
>> psql:/usr/local/src/postgresql-7.4.1/contrib/postgis-0.8.1/postgis.sql:555:
>> NOTICE:  argument type wkb
>> is only a shell
>> CREATE FUNCTION
>> psql:/usr/local/src/postgresql-7.4.1/contrib/postgis-0.8.1/postgis.sql:560:
>> NOTICE:  argument type wkb
>> is only a shell
>> CREATE FUNCTION
>> psql:/usr/local/src/postgresql-7.4.1/contrib/postgis-0.8.1/postgis.sql:566:
>> NOTICE:  argument type wkb
>> is only a shell
>> CREATE FUNCTION
>> psql:/usr/local/src/postgresql-7.4.1/contrib/postgis-0.8.1/postgis.sql:571:
>> NOTICE:  argument type wkb
>> is only a shell
>> CREATE FUNCTION
>> psql:/usr/local/src/postgresql-7.4.1/contrib/postgis-0.8.1/postgis.sql:576:
>> NOTICE:  argument type wkb
>> is only a shell
>> CREATE FUNCTION
>> psql:/usr/local/src/postgresql-7.4.1/contrib/postgis-0.8.1/postgis.sql:581:
>> NOTICE:  argument type wkb
>> is only a shell
>> CREATE FUNCTION
>> psql:/usr/local/src/postgresql-7.4.1/contrib/postgis-0.8.1/postgis.sql:587:
>> NOTICE:  argument type wkb
>> is only a shell
>> CREATE FUNCTION
>> psql:/usr/local/src/postgresql-7.4.1/contrib/postgis-0.8.1/postgis.sql:592:
>> NOTICE:  argument type wkb
>> is only a shell
>> CREATE FUNCTION
>> psql:/usr/local/src/postgresql-7.4.1/contrib/postgis-0.8.1/postgis.sql:597:
>> NOTICE:  argument type wkb
>> is only a shell
>> CREATE FUNCTION
>> psql:/usr/local/src/postgresql-7.4.1/contrib/postgis-0.8.1/postgis.sql:602:
>> NOTICE:  argument type wkb
>> is only a shell
>> CREATE FUNCTION
>> psql:/usr/local/src/postgresql-7.4.1/contrib/postgis-0.8.1/postgis.sql:607:
>> NOTICE:  argument type wkb
>> is only a shell
>> CREATE FUNCTION
>> psql:/usr/local/src/postgresql-7.4.1/contrib/postgis-0.8.1/postgis.sql:612:
>> NOTICE:  argument type wkb
>> is only a shell
>> CREATE FUNCTION
>> psql:/usr/local/src/postgresql-7.4.1/contrib/postgis-0.8.1/postgis.sql:619:
>> NOTICE:  argument type wkb
>> is only a shell
>> CREATE FUNCTION
>> psql:/usr/local/src/postgresql-7.4.1/contrib/postgis-0.8.1/postgis.sql:624:
>> NOTICE:  argument type wkb
>> is only a shell
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE AGGREGATE
>> CREATE FUNCTION
>> CREATE AGGREGATE
>> CREATE FUNCTION
>> CREATE AGGREGATE
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE OPERATOR
>> CREATE OPERATOR
>> CREATE OPERATOR
>> CREATE OPERATOR
>> CREATE OPERATOR
>> CREATE OPERATOR
>> CREATE OPERATOR
>> CREATE OPERATOR
>> CREATE OPERATOR
>> CREATE OPERATOR
>> CREATE OPERATOR
>> CREATE OPERATOR
>> CREATE OPERATOR
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE AGGREGATE
>> CREATE FUNCTION
>> CREATE AGGREGATE
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE TYPE
>> CREATE CAST
>> CREATE CAST
>> CREATE CAST
>> CREATE CAST
>> CREATE CAST
>> CREATE CAST
>> CREATE CAST
>> CREATE CAST
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE OPERATOR CLASS
>> UPDATE 1
>> CREATE OPERATOR CLASS
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> CREATE FUNCTION
>> COMMIT
>>
>> Thank you very much
>>
>> Carlos FG
>>
>>
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
> Carlos FG
>
> Conheça a Região Metropolitana de São Paulo:
> http://www.mapas.centrodametropole.org.br/servidormapas/html/index.html
>
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

Carlos FG

Conheça a Região Metropolitana de São Paulo:
http://www.mapas.centrodametropole.org.br/servidormapas/html/index.html