[postgis-users] Installing PostGIS - problem

Hao Ding hdi12 at it.canterbury.ac.nz
Tue Jul 9 16:19:56 PDT 2002


Hi Alan,

I met the similar problem as you and have not solved it so far.  Did you got 
the idea to deal with it? If yes, could you please tell me?

Regards,
Hao

>===== Original Message From postgis-users at postgis.refractions.net =====
>Hi,
>
>I have installed postgresql OK  (Redhat Linux).
>
>When installing PostGIS all goes well until
>psql -d yourdatabase -f postgis.sql
>
>Below is the log file showing notices and errors. Any suggestions would be 
appreciated.
>
>Regards,
>Alan
>
>020705.16:38:40.104 [10646] DEBUG:  Data Base System is starting up at Fri 
Jul  5 16:38:40 2002
>020705.16:38:40.104 [10646] DEBUG:  Data Base System was shut down at Fri Jul
 5 16:38:27 2002
>020705.16:38:40.106 [10646] DEBUG:  Data Base System is in production state 
at Fri Jul  5 16:38:40 2002
>020705.16:38:54.528 [10649] NOTICE:  CREATE TABLE/PRIMARY KEY will create 
implicit index 'spatial_ref_sys_pkey' for table 'spatial_ref_sys'
>020705.16:38:54.543 [10649] NOTICE:  CREATE TABLE/PRIMARY KEY will create 
implicit index 'gc_pk' for table 'geometry_columns'
>020705.16:38:54.556 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.562 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.567 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.571 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.575 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.577 [10649] NOTICE:  ProcedureCreate: type 'box3d' is not yet 
defined
>020705.16:38:54.582 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.586 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.588 [10649] NOTICE:  ProcedureCreate: type 'spheroid' is not 
yet defined
>020705.16:38:54.592 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.601 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.603 [10649] NOTICE:  ProcedureCreate: type 'wkb' is not yet 
defined
>020705.16:38:54.608 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.612 [10649] NOTICE:  DefineType: attribute "storage" not 
recognized
>020705.16:38:54.617 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.619 [10649] NOTICE:  ProcedureCreate: type 'chip' is not yet 
defined
>020705.16:38:54.623 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.627 [10649] NOTICE:  DefineType: attribute "storage" not 
recognized
>020705.16:38:54.632 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.636 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.640 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.644 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.648 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.652 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.656 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.660 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.664 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.666 [10649] NOTICE:  ProcedureCreate: type 'geometry' is not 
yet defined
>020705.16:38:54.671 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.675 [10649] NOTICE:  DefineType: attribute "storage" not 
recognized
>020705.16:38:54.679 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.684 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.688 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.692 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.696 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.700 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.705 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.709 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.713 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.718 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.722 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.724 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.725 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.725 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.725 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.726 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.726 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.727 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.727 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.728 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.728 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.729 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.729 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.730 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.730 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.731 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.731 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.732 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.732 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.733 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.733 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.739 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.743 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.747 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.751 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.755 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.760 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.764 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.764 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.765 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.765 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.766 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.766 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.767 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.767 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.768 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.768 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.769 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.769 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.769 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.770 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.770 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.771 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.771 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.772 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.772 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.773 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.773 [10649] NOTICE:  Unrecognized function attribute 
'isstrict' ignored
>020705.16:38:54.782 [10649] NOTICE:  DefineAggregate: attribute "sfunc" not 
recognized
>020705.16:38:54.783 [10649] NOTICE:  DefineAggregate: attribute "stype" not 
recognized
>020705.16:38:54.783 [10649] ERROR:  AggregateCreate: aggregate must have at 
least one transition function
>020705.16:38:54.786 [10649] NOTICE:  current transaction is aborted, queries 
ignored until end of transaction block
>020705.16:38:54.787 [10649] NOTICE:  current transaction is aborted, queries 
ignored until end of transaction block
>020705.16:38:54.787 [10649] NOTICE:  current transaction is aborted, queries 
ignored until end of transaction block
>020705.16:38:54.787 [10649] NOTICE:  current transaction is aborted, queries 
ignored until end of transaction block
>020705.16:38:54.787 [10649] NOTICE:  current transaction is aborted, queries 
ignored until end of transaction block
>020705.16:38:54.787 [10649] NOTICE:  current transaction is aborted, queries 
ignored until end of transaction block
>020705.16:38:54.788 [10649] NOTICE:  current transaction is aborted, queries 
ignored until end of transaction block
>020705.16:38:54.788 [10649] NOTICE:  current transaction is aborted, queries 
ignored until end of transaction block
>020705.16:38:54.788 [10649] NOTICE:  current transaction is aborted, queries 
ignored until end of transaction block
>020705.16:38:54.788 [10649] NOTICE:  current transaction is aborted, queries 
ignored until end of transaction block
>020705.16:38:54.788 [10649] NOTICE:  current transaction is aborted, queries 
ignored until end of transaction block
>020705.16:38:54.789 [10649] NOTICE:  current transaction is aborted, queries 
ignored until end of transaction block
>020705.16:38:54.789 [10649] NOTICE:  current transaction is aborted, queries 
ignored until end of transaction block
>020705.16:38:54.789 [10649] NOTICE:  current transaction is aborted, queries 
ignored until end of transaction block
>020705.16:38:54.789 [10649] NOTICE:  current transaction is aborted, queries 
ignored until end of transaction block
>020705.16:38:54.789 [10649] NOTICE:  current transaction is aborted, queries 
ignored until end of transaction block
>020705.16:38:54.790 [10649] NOTICE:  current transaction is aborted, queries 
ignored until end of transaction block
>020705.16:38:54.790 [10649] NOTICE:  current transaction is aborted, queries 
ignored until end of transaction block
>020705.16:38:54.791 [10649] ERROR:  ProcedureCreate: arg type 'geometry' is 
not defined
>020705.16:38:54.791 [10649] NOTICE:  current transaction is aborted, queries 
ignored until end of transaction block
>020705.16:38:54.791 [10649] NOTICE:  current transaction is aborted, queries 
ignored until end of transaction block
>020705.16:38:54.792 [10649] NOTICE:  current transaction is aborted, queries 
ignored until end of transaction block
>020705.16:38:54.792 [10649] NOTICE:  current transaction is aborted, queries 
ignored until end of transaction block
>020705.16:38:54.792 [10649] NOTICE:  current transaction is aborted, queries 
ignored until end of transaction block
>020705.16:38:54.792 [10649] NOTICE:  current transaction is aborted, queries 
ignored until end of transaction block
>020705.16:38:54.792 [10649] NOTICE:  current transaction is aborted, queries 
ignored until end of transaction block
>020705.16:38:54.792 [10649] NOTICE:  current transaction is aborted, queries 
ignored until end of transaction block
>020705.16:38:54.793 [10649] NOTICE:  current transaction is aborted, queries 
ignored until end of transaction block
>020705.16:38:54.793 [10649] NOTICE:  current transaction is aborted, queries 
ignored until end of transaction block
>020705.16:38:54.793 [10649] NOTICE:  current transaction is aborted, queries 
ignored until end of transaction block
>020705.16:38:54.793 [10649] NOTICE:  current transaction is aborted, queries 
ignored until end of transaction block
>020705.16:38:54.794 [10649] NOTICE:  current transaction is aborted, queries 
ignored until end of transaction block
>020705.16:38:54.796 [10649] NOTICE:  current transaction is aborted, queries 
ignored until end of transaction block
>020705.16:38:54.796 [10649] NOTICE:  current transaction is aborted, queries 
ignored until end of transaction block
>020705.16:38:54.797 [10649] NOTICE:  current transaction is aborted, queries 
ignored until end of transaction block
>020705.16:38:54.797 [10649] NOTICE:  current transaction is aborted, queries 
ignored until end of transaction block
>020705.16:38:54.797 [10649] NOTICE:  current transaction is aborted, queries 
ignored until end of transaction block
>020705.16:38:54.797 [10649] NOTICE:  current transaction is aborted, queries 
ignored until end of transaction block
>020705.16:38:54.797 [10649] NOTICE:  current transaction is aborted, queries 
ignored until end of transaction block
>020705.16:38:54.798 [10649] NOTICE:  current transaction is aborted, queries 
ignored until end of transaction block
>020705.16:38:54.799 [10649] ERROR:  Relation 'pg_opclass' does not have 
attribute 'opcamid'
>020705.16:38:54.799 [10649] NOTICE:  current transaction is aborted, queries 
ignored until end of transaction block
>020705.16:38:54.800 [10649] ERROR:  Relation 'rt_ops_tmp' does not exist
>020705.16:38:54.800 [10649] ERROR:  Relation 'rt_ops_tmp' does not exist
>020705.16:38:54.801 [10649] ERROR:  Relation 'rt_ops_tmp' does not exist
>020705.16:38:54.801 [10649] ERROR:  Relation 'rt_ops_tmp' does not exist
>020705.16:38:54.801 [10649] ERROR:  Relation 'rt_ops_tmp' does not exist
>020705.16:38:54.802 [10649] ERROR:  Relation 'rt_ops_tmp' does not exist
>020705.16:38:54.802 [10649] ERROR:  Relation 'rt_ops_tmp' does not exist
>020705.16:38:54.802 [10649] ERROR:  Relation 'rt_ops_tmp' does not exist
>020705.16:38:54.802 [10649] NOTICE:  current transaction is aborted, queries 
ignored until end of transaction block
>020705.16:38:54.803 [10649] ERROR:  Attribute 'opcamid' not found
>020705.16:38:54.804 [10649] ERROR:  Attribute 'opcamid' not found
>020705.16:38:54.804 [10649] ERROR:  Attribute 'opcamid' not found
>020705.16:38:54.804 [10649] ERROR:  Attribute 'opcamid' not found
>020705.16:38:54.805 [10649] ERROR:  Attribute 'opcamid' not found
>020705.16:38:54.805 [10649] ERROR:  Attribute 'opcamid' not found
>020705.16:38:54.806 [10649] ERROR:  Attribute 'opcamid' not found






More information about the postgis-users mailing list