tudelft3d / bag3d

Software for generating a 3D version of the BAG dataset and more. Python + PostgreSQL + 3dfier
GNU General Public License v3.0
11 stars 11 forks source link

"3dbag" schema in PostgreSQL backup not created before used #30

Closed bwbroersma closed 3 years ago

bwbroersma commented 5 years ago

The bag3d_2019-05-28.backup found on http://3dbag.bk.tudelft.nl/downloads will fail to execute CREATE TABLE "3dbag".pand3d (...); since the schema "3dbag" doesn't exist yet since it's not created in the backup nor in bagactueel_schema.backup.

Of course it works if we add it to the create extension command: psql -d <db> -c 'create extension postgis;create schema "3dbag";'

Maybe also note a schema creation here? https://github.com/tudelft3d/bag3d/blob/0a8e619489d2d044b55782eabd6bd4419a393ba3/bag3d/exporter.py#L230