[postgis-users] loading data into postgres

strk strk at keybit.net
Wed Apr 7 04:49:40 PDT 2004


What version of postgis is installed in 'yourtestdatabase' ?
What verison of postgis created the postgis.sql you are trying to source ?
--strk;

On Wed, Apr 07, 2004 at 07:10:31AM -0400, dkittler at customerportfolios.com wrote:
> 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
> 
> 
> _______________________________________________
> 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