[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