[postgis-users] Error executing postgis.sql

[Tyler Mitchell]

Danny, could you tell us more about your setup?  Did you compile postgresql
yourself or are you using a stock version?  I assume you're on some *nix
operating system.  Are you sure that the postgis.sql that you are loading
is from the same version of the postgis libraries you installed?

postgis-users-bounces at postgis.refractions.net wrote on 01/20/2004 06:54:06
AM:

> Hey all...
>
> I am trying to import postgis.sql into the database I setup and I
> get an error about 3/4 of the way through.
>
> I am getting:
> psql:postgis.sql:1004: ERROR:  could not find function "centroid" in
> file "/opt/WM/db/lib/postgresql/libpostgis.so.0.8"
>
> Any thoughts would be very appreciated. I checked and the
> libpostgis.so.0.8 file is included in that directory. I tried
> looking through the list to see if this was a past issue, but
> couldn't find anything.
>
> ~Danny