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

[Robert Burgholzer]

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 <javascript:;>
> 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/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140328/33071be5/attachment.html>