Re: pg_upgrade fails to detect unsupported arrays and ranges

2021-04-28 Thread Tom Lane
Daniel Gustafsson writes: > On 28 Apr 2021, at 22:47, Tom Lane wrote: >> This wording is copied-and-pasted from the other similar tests. I agree >> that it's advocating a solution that might be overkill, but if we change >> it we should also change the existing messages. > Good point. >> I d

Re: pg_upgrade fails to detect unsupported arrays and ranges

2021-04-28 Thread Daniel Gustafsson
> On 28 Apr 2021, at 22:47, Tom Lane wrote: > > Daniel Gustafsson writes: >>> On 28 Apr 2021, at 17:09, Tom Lane wrote: >>> + pg_fatal("Your installation contains system-defined composite >>> type(s) in user tables.\n" >>> +"These type OIDs are not stable

Re: pg_upgrade fails to detect unsupported arrays and ranges

2021-04-28 Thread Tom Lane
Daniel Gustafsson writes: >> On 28 Apr 2021, at 17:09, Tom Lane wrote: >> +pg_fatal("Your installation contains system-defined composite >> type(s) in user tables.\n" >> + "These type OIDs are not stable across >> PostgreSQL versions,\n" >> +

Re: pg_upgrade fails to detect unsupported arrays and ranges

2021-04-28 Thread Daniel Gustafsson
> On 28 Apr 2021, at 17:09, Tom Lane wrote: > > [ blast-from-the-past department ] > > I wrote: >> Daniel Gustafsson writes: >>> I can see the appeal of >>> including it before the wrap, even though I personally would've held off. > >> Nah, I'm not gonna risk it at this stage. I concur with y

Re: pg_upgrade fails to detect unsupported arrays and ranges

2021-04-28 Thread Tom Lane
[ blast-from-the-past department ] I wrote: > Daniel Gustafsson writes: >> I can see the appeal of >> including it before the wrap, even though I personally would've held off. > Nah, I'm not gonna risk it at this stage. I concur with your point > that this is an ancient bug, and one that is unl

Re: pg_upgrade fails to detect unsupported arrays and ranges

2019-11-10 Thread Tom Lane
Daniel Gustafsson writes: > Applies, builds clean and passes light testing. Thanks for checking! > I can see the appeal of > including it before the wrap, even though I personally would've held off. Nah, I'm not gonna risk it at this stage. I concur with your point that this is an ancient bug,

Re: pg_upgrade fails to detect unsupported arrays and ranges

2019-11-10 Thread Daniel Gustafsson
> On 10 Nov 2019, at 22:12, Tom Lane wrote: > > Daniel Gustafsson writes: >> On 10 Nov 2019, at 20:07, Tom Lane wrote: >>> (Note: this patch is shown with --ignore-space-change >>> to make it more reviewable, but I did re-pgindent the code.) Then >>> 0002 actually adds the array and range case

Re: pg_upgrade fails to detect unsupported arrays and ranges

2019-11-10 Thread Daniel Gustafsson
> On 10 Nov 2019, at 22:05, Tom Lane wrote: > Daniel Gustafsson writes: >>> + /* arrays over any type selected so far */ >>> + " SELECT >>> t.oid FROM pg_catalog.pg_type t, x WHERE typelem = x.oid AND typtype = 'b' " > >

Re: pg_upgrade fails to detect unsupported arrays and ranges

2019-11-10 Thread Tom Lane
Daniel Gustafsson writes: > On 10 Nov 2019, at 20:07, Tom Lane wrote: >> (Note: this patch is shown with --ignore-space-change >> to make it more reviewable, but I did re-pgindent the code.) Then >> 0002 actually adds the array and range cases. > Was the source pgindented, but not committed, be

Re: pg_upgrade fails to detect unsupported arrays and ranges

2019-11-10 Thread Tom Lane
Daniel Gustafsson writes: > On 10 Nov 2019, at 20:07, Tom Lane wrote: >> Although this is a really straightforward patch and I've tested it >> against appropriate old versions (9.1 and 9.2), I'm very hesitant >> to shove it in so soon before a release wrap. Should I do that, or >> let it wait ti

Re: pg_upgrade fails to detect unsupported arrays and ranges

2019-11-10 Thread Daniel Gustafsson
> On 10 Nov 2019, at 20:07, Tom Lane wrote: > 0001 refactors the code in question > so that we have only one copy not three-and-growing. The only > difference between the three copies was that one case didn't bother > to search indexes, but I judged that that wasn't an optimization we > need to