Falha de implementação na função write_geojsonb_features()

Depois de sair e entrar novamente no ssh, fazendo todos os passos de wiki / Testes Reais, depois de make all_layers, tentando a publicação com make publicating_geojsons_via, no server...

user@oficalNews2018:/var/gits/_dg/preserv-BR/data/AC/RioBranco/_pk0042.01$   make publicating_geojsons_via

mkdir -m777 -p /tmp/sandbox/_pkBR421_001/BR/data/AC/RioBranco/_pk0042.01/via
--- Gerando arquivos de pontos em /tmp/sandbox/_pkBR421_001/BR/data/AC/RioBranco/_pk0042.01/via ---
psql postgres://postgres@localhost/ingest1 -c "SELECT ingest.publicating_geojsons('via','BR-AC-RioBranco','/tmp/sandbox/_pkBR421_001/BR/data/AC/RioBranco/_pk0042.01/via');"
 publicating_geojsons 
----------------------
 fim
(1 row)

--- Gerando geomosaico em /tmp/sandbox/_pkBR421_001/BR/data/AC/RioBranco/_pk0042.01/via ---
psql postgres://postgres@localhost/ingest1 -c "DROP VIEW IF EXISTS vw3_pk7600004201301_p3_via_publicating;"
NOTICE:  view "vw3_pk7600004201301_p3_via_publicating" does not exist, skipping
DROP VIEW
psql postgres://postgres@localhost/ingest1 -c "CREATE VIEW vw3_pk7600004201301_p3_via_publicating AS SELECT * FROM  geohash_GeomsMosaic_jinfo( (SELECT lineage->'ghs_distrib_mosaic' from ingest.donated_packcomponent WHERE id=(SELECT id FROM ingest.vw08info_packcomponent WHERE isolabel_ext='BR-AC-RioBranco')), '{\"density_km2\":\"val\"}'::jsonb, (SELECT geom FROM ingest.fdw_foreign_jurisdiction_geom where isolabel_ext='BR-AC-RioBranco'));"
CREATE VIEW
psql postgres://postgres@localhost/ingest1 -c "SELECT write_geojsonb_features('vw3_pk7600004201301_p3_via_publicating','/tmp/sandbox/_pkBR421_001/BR/data/AC/RioBranco/_pk0042.01/via/geohashes.geojson', 't1.geom', 'ghs, (info->''val'')::int AS val, (info->''lghs'')::int AS lghs, (info->''val_density_km2'')::float AS val_density_km2', NULL, NULL, 3, 5);"
ERROR:  more than one row returned by a subquery used as an expression
CONTEXT:  SQL statement "
        SELECT volat_file_write(
                '/tmp/sandbox/_pkBR421_001/BR/data/AC/RioBranco/_pk0042.01/via/geohashes.geojson',
                jsonb_pretty_lines( jsonb_build_object('type','FeatureCollection', 'features', gj), 3)
             )
        FROM (
          SELECT jsonb_agg( 
        ST_AsGeoJSONb( t1.geom, 5, 0, NULL, to_jsonb(t2), NULL, NULL, false) 
         ) AS gj
          FROM vw3_pk7600004201301_p3_via_publicating t1 , LATERAL (SELECT ghs, (info->'val')::int AS val, (info->'lghs')::int AS lghs, (info->'val_density_km2')::float AS val_density_km2) t2
        ) t3
       "
PL/pgSQL function write_geojsonb_features(text,text,text,text,text[],text,integer,integer,integer,text,text,boolean) line 50 at EXECUTE
make: *** [makefile:188: publicating_geojsons_via] Error 1

digital-guard / preserv

Falha de implementação na função write_geojsonb_features() #68