[postgis-users] loading data into postgres

dkittler at customerportfolios.com dkittler at customerportfolios.com
Wed Apr 7 04:10:31 PDT 2004


the command  'psql -d yourtestdatabase -f postgis.sql'
creates the follwing console output:

psql:postgis.sql:1022: ERROR:  could not find function "centroid" in
file "/usr/local/pgsql/lib/libpostgis.so.0.8"
psql:postgis.sql:1027: ERROR:  current transaction is aborted, commands
ignored until end of transaction block
psql:postgis.sql:1032: ERROR:  current transaction is aborted, commands
ignored until end of transaction block
psql:postgis.sql:1043: ERROR:  current transaction is aborted, commands
ignored until end of transaction
...

and for the command: psql -d yourtestdatabase -f spatial_ref_sys.sql
i get the same transaction aborted message.

when i do a show all on the database i see some data structures ...
              name              |    setting
--------------------------------+----------------
 add_missing_from               | on
 australian_timezones           | off
 authentication_timeout         | 60
 check_function_bodies          | on
 checkpoint_segments            | 3
 checkpoint_timeout             | 300
 checkpoint_warning             | 30
 client_encoding                | SQL_ASCII
 client_min_messages            | notice
...

but when i try to do a select against any of them i get
a 'relationship' does not exist error.

again, your help is greatly appreciated.
-derrick





More information about the postgis-users mailing list