Re: pg_upgrade and materialized views - Mailing list pgsql-bugs

From Victor Yegorov
Subject Re: pg_upgrade and materialized views
Date
Msg-id CAGnEboipw-MY+beePKfhYO9c+Vqi_c44n-Fhr+2vN4H5VDHMnw@mail.gmail.com
Whole thread Raw
In response to Re: pg_upgrade and materialized views  (Claudio Freire <klaussfreire@gmail.com>)
Responses Re: pg_upgrade and materialized views
List pgsql-bugs
2018-02-21 0:56 GMT+02:00 Claudio Freire <klaussfreire@gmail.com>:
Well, the attached script reproduces the issue.

Make a scratch dir somewhere, cd into it, and run it. It will download
9.6.7 and 10.2, build them, create a test db in 9.6.7, modify it a bit
here and there to get to the desired state, pg_upgrade it to 10.2 and
vacuum.

Might even be a good idea to create a regression test with that, but
AFAIK there's nothing remotely like that in the current tests.

The patch you propose makes the test succeed. It may be true that
there might be other similar issues lurking in that code, but it looks
like it fixes this particular issue.

Is it possible, that bug #14852 is of the same nature as the issue at hand here?

pgsql-bugs by date:

Previous
From: Sudalai
Date:
Subject: Re: Segmentation Fault in logical decoding get/peek API
Next
From: Tomas Vondra
Date:
Subject: Re: Segmentation Fault in logical decoding get/peek API