[postgis-users] Installing PostGIS - problem

Hao Ding hdi12 at it.canterbury.ac.nz
Wed Jul 10 16:38:57 PDT 2002 

Hi Alan,

Thanks for your comment.  I installed latest Postgresql 7.2.1, but found that 
Postgresql 7.1.3 was already in the system.  Now the problem has solved.

Regards,
Hao

>===== Original Message From postgis-users at postgis.refractions.net =====
>Hi Hao,
>
>I did discover that PostgreSQL 7.0.3 was already installed on my Linux system 
(I inherited the installation), so this was the most likely cause of my 
problem - you need 7.1 or 7.2. You can check which version you are using by
>
>$> psql mydbase
>$> select version();
>
>I have since been distracted from the task of installing but I will let you 
know how it goes.
>
>Regards,
>Alan
>
>>> hdi12 at it.canterbury.ac.nz 07/10/02 09:19am >>>
>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 blockOTICE
>>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
>
>
>
>_______________________________________________
>postgis-users mailing list
>postgis-users at postgis.refractions.net
>http://postgis.refractions.net/mailman/listinfo/postgis-users

More information about the postgis-users mailing list