On 27/08/18 15:22, Tom Lane wrote: >> That's not supposed to happen. Can you create a test case, by any chance? >> Presumably, it's triggered by some database schema change you made since >> the last successful dump. >> >> regards, tom lane >>
It wasn't the cross-tab/pivot, it was this materialized view: CREATE materialized VIEW r.b AS SELECT c.id, f.ytext, min(coalesce( (select case when wb.prop >= 0.333 then 4 when wb.prop >= 0.25 then 3 when wb.prop >= 0.15 then 2 when wb.prop >= 0.1 then 1 else 0 end FROM r.wb where wb.cid = c.id and wb.fid = f.id), 0)) as score FROM rating.cy, c, f WHERE c.id = f.cid AND f.cid = cy.cid AND f.ye = cy.ye GROUP BY 1, 2 LIMIT 1; I've trimmed it down to even just one row and it still causes the warning "pg_dump: [archiver] WARNING: archive items not in correct section order" It yields this data: id | ytext | score -----------+----------+------- 5 | 1996 | 0 -- Tim Clarke
