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 <[email protected]> > An: [email protected] > 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 > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
