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

[samclemmens]

Sorry; I inadvertently posted my previous response twice...   The line is:

psql:postgis/postgis.sql:80: ERROR:  type "spheroid" already exists

So, does this mean that my spatial database was successfully created the
first time around despite the "notices" that the spatial functions (e.g.,
st_max_distance) do not exist?



Kevin Neufeld wrote:
> 
> These are not the ERRORs messages Devrim was referring to.  These are 
> merely NOTICEs that are typical for a PostGIS installation.  Before all 
> the "ERROR: transaction was aborted" log entries you reported, there 
> should be a line that indicates what caused the transaction to roll back.
> 
> -- Kevin
> 
> On 5/27/2010 2:14 AM, Peter Cotroneo wrote:
>>
>> Hi Devrim,
>>
>> Thanks for your reply. 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.
>>
>> As I mentioned yesterday, make check works just fine (i.e., it creates 
>> the spatial database postgis_reg).
>>
>> Cheers,
>>
>> Petrus
>>
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>    
> 
> _______________________________________________
> 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-tp28691440p28707299.html
Sent from the PostGIS - User mailing list archive at Nabble.com.