[postgis-users] PostGIS: make check works, but I can't manually create a spatial database

[samclemmens]

Here’s what I get immediately after trying to create a spatial database:

[root at ip-10-224-82-127 postgis-1.5.0SVN]# sudo -u postgres createdb testdb
[root at ip-10-224-82-127 postgis-1.5.0SVN]# sudo -u postgres createlang
plpgsql testdb
[root at 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 at 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.