> [*] postgis.sql for PostGIS 1.4 and later I believe. I'm using postgis-1.5, installed using homebrew
> There's two files named lwpostgis.sql* and spatial_ref_sys.sql which are in > your PostGIS package somewhere. You need to run them on your database after > you have done the createdb and the createlang plpgsql. The following resulted in some oddness. I'm wondering if I need to re-install with macports, or one of the KyngChaos releases.. or I'm just missing something. I appreciate thoughts. Chris ===================== $ psql -d gis -f /usr/local/pgsql/share/contrib/postgis-1.5/postgis.sql SET BEGIN psql:/usr/local/pgsql/share/contrib/postgis-1.5/postgis.sql:59: ERROR: could not access file "$libdir/postgis-1.5": No such file or directory psql:/usr/local/pgsql/share/contrib/postgis-1.5/postgis.sql:65: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/usr/local/pgsql/share/contrib/postgis-1.5/postgis.sql:70: ERROR: current transaction is aborted, commands ignored until end of transaction block ... ... ... ROLLBACK psql:/usr/local/pgsql/share/contrib/postgis-1.5/postgis.sql:7746: ERROR: type "geometry" does not exist psql:/usr/local/pgsql/share/contrib/postgis-1.5/postgis.sql:7747: ERROR: type "geometry" does not exist ... psql:/usr/local/pgsql/share/contrib/postgis-1.5/postgis.sql:7752: ERROR: type "box2d" does not exist ... DROP FUNCTION DROP FUNCTION psql:/usr/local/pgsql/share/contrib/postgis-1.5/postgis.sql:7775: ERROR: type "geometry" does not exist ===================== _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
