oq-engine --rr job_risk.ini --hazard-output-id XX --no-distribute
...
File "<oq engine path>/calculators/risk/hazard_getters.py", line 326, in __init__cursor.execute(self.assoc_query)File "/Users/Lukas/.virtualenv/openquake/lib/python2.7/site-packages/django/db/backends/postgresql_psycopg2/base.py", line 44, in executereturn self.cursor.execute(query, args)DatabaseError: syntax error at or near "INSERT"LINE 10: INSERT INTO riskr.asset_site (job_id, asset_id, site_id)^
--
You received this message because you are subscribed to the Google Groups "OpenQuake Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openquake-use...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
oq-engine --rh job_hazard.ini --no-distribute
id | output_type | name7133 | Hazard Curve | Hazard Curve rlz-1281-PGA7132 | Hazard Curve (multiple imts) | hc-multi-imt-rlz-1281
WITH assocs AS (FROM riski.exposure_data AS expJOIN hzrdi.hazard_site AS hsiteON exp.site::text = hsite.location::textWHERE hsite.hazard_calculation_id = 105AND exposure_model_id = 5 AND taxonomy=E'RC'AND ST_COVERS(ST_GeographyFromText(E'POLYGON ((78.0000000000000000 31.5000000000000000, 89.5000000000000000 31.5000000000000000, 89.5000000000000000 25.5000000000000000, 78.0000000000000000 25.5000000000000000, 78.0000000000000000 31.5000000000000000))'), exp.site))
INSERT INTO riskr.asset_site (job_id, asset_id, site_id)
SELECT * FROM assocs
Actually I think this might be due to the fact that I'm running postgres 9.0. From the documentation it looks like this kind of statement is only supported with 9.1.
--
You received this message because you are subscribed to the Google Groups "OpenQuake Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openquake-use...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.