Here’s what I get immediately after trying to create a spatial database:
[r...@ip-10-224-82-127 postgis-1.5.0SVN]# sudo -u postgres createdb testdb [r...@ip-10-224-82-127 postgis-1.5.0SVN]# sudo -u postgres createlang plpgsql testdb [r...@ip-10-224-82-127 postgis-1.5.0SVN]# sudo -u postgres psql -d testdb -f postgis/postgis.sql BEGIN psql:postgis/postgis.sql:57: NOTICE: type "spheroid" is not yet defined DETAIL: Creating a shell type definition. CREATE FUNCTION psql:postgis/postgis.sql:63: NOTICE: argument type spheroid is only a shell CREATE FUNCTION psql:postgis/postgis.sql:68: NOTICE: return type spheroid is only a shell CREATE FUNCTION psql:postgis/postgis.sql:73: NOTICE: argument type spheroid is only a shell CREATE FUNCTION CREATE TYPE psql:postgis/postgis.sql:90: NOTICE: type "geometry" is not yet defined DETAIL: Creating a shell type definition. ...and so on... Devrim GÜNDÜZ wrote: > > On Wed, 2010-05-26 at 12:16 +0100, Peter Cotroneo wrote: >> >> When I try to create a spatial database (e.g., psql -d geodb -f >> postgis.sql), however, it doesn't work. I get numerous errors that >> look as follows: >> >> psql:postgis.sql:7739: ERROR: current transaction is aborted, >> commands ignored until end of transaction block > > There should be something different before this. Could you please paste > it? > > BTW, did you load plpgsql before running postgis.sql script? > -- > Devrim GÜNDÜZ > PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer > PostgreSQL RPM Repository: http://yum.pgrpms.org > Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr > http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz > > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > > -- View this message in context: http://old.nabble.com/PostGIS%3A-make-check-works%2C-but-I-can%27t-manually-create-a-spatial-%09database-tp28679308p28707160.html Sent from the PostGIS - User mailing list archive at Nabble.com. _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
