statistics import and export: another difference in dump/restore

2025-04-05 Thread Ashutosh Bapat
Hi Jeff and Corey, Thanks for fixing the bug related to materialized view statistics. I have now submitted patches so that the test compares statistics as well. [1]. However, it is showing a failure on windows only [2]. regress_log has the following difference. @@ -444546,7 +444546,7 @@ 'relname

Re: statistics import and export: another difference in dump/restore

2025-04-02 Thread Ashutosh Bapat
On Wed, Apr 2, 2025 at 10:55 PM Jeff Davis wrote: > > On Wed, 2025-04-02 at 15:35 +0530, Ashutosh Bapat wrote: > > Once we fix this issue, we need to enable statistics dump and > > comparison in pg_upgrade/002_pg_upgrade using the attached patch. > > The diff appears to be an issue in 002_pg_upgra

Re: statistics import and export: another difference in dump/restore

2025-04-02 Thread Jeff Davis
On Wed, 2025-04-02 at 15:35 +0530, Ashutosh Bapat wrote: > Once we fix this issue, we need to enable statistics dump and > comparison in pg_upgrade/002_pg_upgrade using the attached patch. The diff appears to be an issue in 002_pg_upgrade.pl introduced in 172259afb5. There are two dumps taken from

Re: statistics import and export: another difference in dump/restore

2025-04-02 Thread Ashutosh Bapat
Hi, On Tue, Apr 1, 2025 at 12:54 PM Ashutosh Bapat wrote: > [1] > https://www.postgresql.org/message-id/caexhw5vvftcejh+uyznxmgsxofj_1xwi5aqhqfemqjgfmky...@mail.gmail.com > [2] https://cirrus-ci.com/task/5164175841820672 I have added this to PG 18 open items. It might be too early to call this