[postgis-users] (3DCityDB) Error with creation of database

[Rémi Cura]

You don't need to do that,
just
'CREATE EXTENSION postgis;'

assuming you have a decently recent postgres and postgis

Cheers,
Rémi-C


2014-03-28 12:26 GMT+01:00 Robert Burgholzer <rburghol at vt.edu>:

> Loojs like postGIS did not get installed.  Two tables are created and
> populated as part of the intall process "geometry_columns" and
> "spatial_ref_sys" - part of install requires executing sql scripts inckuded
> in the install process (this is *nix but the same should apply in win):
>
>
>
>
> createdb yourdatabase
>
> createlang plpgsql yourdatabase
>
> psql -d yourdatabase -f postgis.sql
>
> psql -d yourdatabase -f postgis_comments.sql
>
> psql -d yourdatabase -f spatial_ref_sys.sql
>
> On Friday, March 28, 2014, 3DCityModeler <jo_be at gmx.net> wrote:
>
>> Hi there,
>>
>> To make a Raytracing Analysis of a 3DCity Area I will use the CityGML
>> Format
>> and therefore database format. I decided to choose PostgreSQL with PostGIS
>> and 3DCityDB.
>>
>> But when creating a new database, after entering my password, the SRID and
>> the SRSName the following error occurs:
>>
>>
>> CREATE FUNCTION
>> psql:CREATE_DB.sql:47: ERROR: *Relation ?spatial_ref_sys " is not
>> existing*
>> LINE 1: SELECT srid FROM spatial_ref_sys WHERE srid = $1
>>
>>
>>
>> I am using Windows 7 system.
>>
>> Can somebody help me?
>>
>> Thanks
>>
>>
>>
>> --
>> View this message in context:
>> http://postgis.17.x6.nabble.com/3DCityDB-Error-with-creation-of-database-tp5005987.html
>> Sent from the PostGIS - User mailing list archive at Nabble.com.
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>
>
>
> --
> --
> Robert W. Burgholzer
>  'Making the simple complicated is commonplace; making the complicated
> simple, awesomely simple, that's creativity.'  - Charles Mingus
> Athletics: http://athleticalgorithm.wordpress.com/
> Science: http://robertwb.wordpress.com/
> Wine: http://reesvineyard.wordpress.com/
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140328/29c2c55a/attachment.html>