[postgis] Install test failure

[colmpdx]

Postgres 7.1.3
Postgis  0.6.2

When running

psql -f /software/src/postgresql-7.1.3/contrib/postgis-
0.6.2/postgis.sql -d db


Got the following NOTICES:

psql:/software/src/postgresql-7.1.3/contrib/postgis-
0.6.2/postgis.sql:34: NOTICE:  CREATE TABLE/PRIMARY KEY will create 
implicit index 'spatial_ref_sys_pkey' for table 'spatial_ref_sys'
psql:/software/src/postgresql-7.1.3/contrib/postgis-
0.6.2/postgis.sql:47: NOTICE:  CREATE TABLE/PRIMARY KEY will create 
implicit index 'gc_pk' for table 'geometry_columns'
psql:/software/src/postgresql-7.1.3/contrib/postgis-
0.6.2/postgis.sql:213: NOTICE:  ProcedureCreate: type 'box3d' is not 
yet defined
psql:/software/src/postgresql-7.1.3/contrib/postgis-
0.6.2/postgis.sql:223: NOTICE:  ProcedureCreate: type 'spheroid' is 
not yet defined
psql:/software/src/postgresql-7.1.3/contrib/postgis-
0.6.2/postgis.sql:247: NOTICE:  ProcedureCreate: type 'wkb' is not 
yet defined
psql:/software/src/postgresql-7.1.3/contrib/postgis-
0.6.2/postgis.sql:265: NOTICE:  ProcedureCreate: type 'chip' is not 
yet defined
psql:/software/src/postgresql-7.1.3/contrib/postgis-
0.6.2/postgis.sql:286: NOTICE:  ProcedureCreate: type 'geometry' is 
not yet defined
psql:/software/src/postgresql-7.1.3/contrib/postgis-
0.6.2/postgis.sql:323: NOTICE:  ProcedureCreate: return 
type 'geometry' is only a shell



Then in trying out the USAGE section of the README.postgis file
I created a database called "db".

Edited the SQL to remove tabs etc. Espically the
INSERT INTO SPATIAL_REF_SYS ...

Everything works up to ...

INSERT INTO geotest (id, name, geopoint) VALUES (1, 'Olympia', 
GeometryFromText('POINT(-122.90,46.97)',1));

Gives me the error message ..

ERROR:  couldnt parse object in GEOMETRY

Did I miss something ?

Thanks

-pete




------------------------ Yahoo! Groups Sponsor ---------------------~-->
Tiny Wireless Camera under $80!
Order Now! FREE VCR Commander!
Click Here - Only 1 Day Left!
http://us.click.yahoo.com/WoOlbB/7.PDAA/ySSFAA/PhFolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
postgis-unsubscribe at yahoogroups.com

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/