[postgis-users] Installing PostGIS - problem
Alan WILLMORE
AWILL at doh.health.nsw.gov.au
Tue Jul 9 17:53:07 PDT 2002
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
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: InterScan_Disclaimer.txt
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20020710/d29a6da7/attachment.txt>
More information about the postgis-users
mailing list