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
