restoring sample db fails to materialize network_segment view

[haubourg]

usr/bin/pg_restore --host localhost --port 5432 --username "postgres" --dbname "qgep" --no-password "/home/regis/OSLANDIA/projets_locaux/QGEP/data-demodata/qgep_demodata.backup"

returns following errors:

pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 7468; 0 23690 MATERIALIZED VIEW DATA vw_network_segment postgres
pg_restore: [archiver (db)] could not execute query: ERROR:  function st_curvetoline(public.geometry, integer) does not exist
LINE 1: SELECT ST_CurveToLine($1, 32)
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
QUERY:  SELECT ST_CurveToLine($1, 32)
CONTEXT:  SQL function "st_curvetoline" during inlining
    Command was: REFRESH MATERIALIZED VIEW vw_network_segment;

I suppose that this is a pg_restore error replacing $1 variable by 'public.geometry' when it should be 'geometry'

[tudorbarascu]

I can also replicate. Actually I noticed this some time ago but I got used on doing a refresh materialized view manually so it didn't bother me. Thanks for raising this.

[sjib]

When importing the demo project the materialized view vw_network_segment has to be reinstalled manually - make update of the doku (@sjib)

[sjib]

Check with postgres developers why that view is not exported (@m-kuhn)

[sjib]

Add hint to doku - to do myself

[sjib]

If you have problems with restore (Code 1 instead of 0 and have a message about wrong header) update to latest version of postgres - see also https://stackoverflow.com/questions/49064209/getting-archiver-unsupported-version-1-13-in-file-header-when-running-pg-r
If there is Code 1 but the schema is created and tables are created, just update materialized view - see #409