[postgis-users] CityGML in PostGIS - 3D City Database released

[Felix Kunde]

Hey Babou

I've never tripped over this kind of error before. It looks pretty clear: 
The substitution variable for your second input parameter could not be 
interpreted. Take a look in CREATE_DB.sql in a text editor. Line 50: 

INSERT INTO DATABASE_SRS(SRID,GML_SRS_NAME) VALUES (:SRS_NO,:'GMLSRSNAME');

SRS_NO and GMLSRSNAME are variables defined by your prompt inputs. By using 
colons (:) the variables should be replaced by the values you've entered. 
In the error message you can see, that this happened for SRS_NO but not for 
GMLSRSNAME. I'm sorry, I can't help you with this one. It always worked on 
german and english machines. I don't know if the error is caused by french 
settings as the ' is interpreted differently. I asked another PostgreSQL 
board but got no answer yet. I let you know if I got any news.

Alternatively you can change the file by hardcoding Line 50 to e.g.
INSERT INTO DATABASE_SRS(SRID,GML_SRS_NAME) VALUES (:SRS_NO,'someText');

In fact the value for GML_SRS_NAME is not a mandatory one. It was not my 
idea. I've just ported it that way to the PostGIS version.

Good luck.
Felix


>             
> -------- Original-Nachricht --------
> Datum: Wed, 19 Dec 2012 11:52:25 -0800 (PST)
> Von: babou <hiba.maalaoui at gmail.com>
> An: postgis-users at postgis.refractions.net
> Betreff: Re: [postgis-users] CityGML in PostGIS - 3D City Database 
> released
> 
>             hi,
> thank you Felix, I used SRID 3068 Berlin just to test access to the 
> database
> via the tools Import / export for a  CityGML file.
> I'm currently working with PostGIS 2.0, I have only the table 
> spatial_ref_sys public in my public schema.
> But now a syntax error is displayed despite I used the same syntax used 
> in
> the tutorial (Please enter a valid SRID: 3068 urn: ogc: def: crs, crs: 
> EPSG:
> 6.12:3068, crs: EPSG: 6.12:5783)
> and this error is repeated with any SRID entered.
> <http://postgis.17.n6.nabble.com/file/n5002106/database.png> 
> <http://postgis.17.n6.nabble.com/file/n5002106/batfile_1.png> 
> 
> 
> 
> --
> View this message in context: 
> http://postgis.17.n6.nabble.com/CityGML-in-PostGIS-3D-City-Database-released-tp4998980p5002106.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
> 
        
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20121221/fd54b8d1/attachment.html>