<html>
<head />
<body>
Hey Babou<br /><br />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: <br /><br />INSERT INTO DATABASE_SRS(SRID,GML_SRS_NAME) VALUES (:SRS_NO,:'GMLSRSNAME');<br /><br />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.<br /><br />Alternatively you can change the file by hardcoding Line 50 to e.g.<br />INSERT INTO DATABASE_SRS(SRID,GML_SRS_NAME) VALUES (:SRS_NO,<font color="#800080">'someText'</font>);<br /><br />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.<br /><br />Good luck.<br />Felix<br /><br /><blockquote type="cite">
<p>-------- Original-Nachricht --------<br />Datum: Wed, 19 Dec 2012 11:52:25 -0800 (PST)<br />Von: babou <hiba.maalaoui@gmail.com><br />An: postgis-users@postgis.refractions.net<br />Betreff: Re: [postgis-users] CityGML in PostGIS - 3D City Database released<br /><br /></p>
hi,<br />thank you Felix, I used SRID 3068 Berlin just to test access to the database<br />via the tools Import / export for a CityGML file.<br />I'm currently working with PostGIS 2.0, I have only the table <br />spatial_ref_sys public in my public schema.<br />But now a syntax error is displayed despite I used the same syntax used in<br />the tutorial (Please enter a valid SRID: 3068 urn: ogc: def: crs, crs: EPSG:<br />6.12:3068, crs: EPSG: 6.12:5783)<br />and this error is repeated with any SRID entered.<br /><http://postgis.17.n6.nabble.com/file/n5002106/database.png> <br /><http://postgis.17.n6.nabble.com/file/n5002106/batfile_1.png> <br /><br /><br /><br />--<br />View this message in context: http://postgis.17.n6.nabble.com/CityGML-in-PostGIS-3D-City-Database-released-tp4998980p5002106.html<br />Sent from the PostGIS - User mailing list archive at Nabble.com.<br />_______________________________________________<br />postgis-users mailing list<br />postgis-users@lists.osgeo.org<br />http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users<br /></blockquote>
</body>
</html>