BAGv2 SQL errors #331
Description
Het uitvoeren van een aantal SQL scripts door etl.sh faalt:
2021-11-19 18:34:02,138 fileinput INFO Read/parse for start for file=sql/fill-reltables.sql....
2021-11-19 18:34:02,296 fileinput INFO Read/parse ok for file=sql/fill-reltables.sql
2021-11-19 18:34:02,345 dboutput INFO executing SQL
2021-11-19 18:34:02,368 postgis INFO Connecting to dbname=bagv2 user=bag host=dbserver port=5432
2021-11-19 18:34:03,173 postgis DEBUG Connected to database bagv2
2021-11-19 18:34:03,507 postgis ERROR error column "aanduidingrecordinactief" does not exist
LINE 24: aanduidingRecordInactief,
^
HINT: There is a column named "aanduidingrecordinactief" in table "verblijfsobjectpand", but it cannot be referenced from this part of the query.
in query: -- Fills the (Legacy) relation tables and nevenadres.
2021-11-19 18:34:03,522 fileinput INFO Read/parse for start for file=sql/create-views.sql....
2021-11-19 18:34:03,523 fileinput INFO Read/parse ok for file=sql/create-views.sql
2021-11-19 18:34:03,524 dboutput INFO executing SQL
2021-11-19 18:34:03,524 postgis INFO Connecting to dbname=bagv2 user=bag host=dbserver port=5432
2021-11-19 18:34:03,613 postgis DEBUG Connected to database bagv2
2021-11-19 18:34:03,837 postgis ERROR error column "begindatumtijdvakgeldigheid" does not exist
LINE 18: beginDatumTijdvakGeldigheid <= LOCALTIMESTAMP
^
in query: -- Views voor BAG tabellen
2021-11-19 18:34:03,868 fileinput INFO Read/parse for start for file=sql/create-indexes.sql....
2021-11-19 18:34:03,922 fileinput INFO Read/parse ok for file=sql/create-indexes.sql
2021-11-19 18:34:03,923 dboutput INFO executing SQL
2021-11-19 18:34:03,923 postgis INFO Connecting to dbname=bagv2 user=bag host=dbserver port=5432
2021-11-19 18:34:03,976 postgis DEBUG Connected to database bagv2
2021-11-19 18:34:05,018 postgis ERROR error column "geovlak" does not exist
in query: -- Author: Just van den Broecke
Ook adres.sh faalt:
2021-11-19 18:34:24,640 fileinput INFO Read/parse for start for file=sql/adres/adres-tabel.sql....
2021-11-19 18:34:24,641 fileinput INFO Read/parse ok for file=sql/adres/adres-tabel.sql
2021-11-19 18:34:24,641 fileinput INFO all files done
2021-11-19 18:34:24,641 dboutput INFO executing SQL
2021-11-19 18:34:24,641 postgis INFO Connecting to dbname=bagv2 user=bag host=dbserver port=5432
2021-11-19 18:34:24,727 postgis DEBUG Connected to database bagv2
2021-11-19 18:34:25,001 postgis ERROR error relation "verblijfsobjectactueelbestaand" does not exist
LINE 54: FROM verblijfsobjectactueelbestaand v
^
in query: --
Dit is met GDAL 3.3.3 op Debian unstable, en de (volledige) lvbag-extract-nl.zip data uit de Atom feed.