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