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

From Claudio Freire
Subject Re: pg_upgrade and materialized views
Date
Msg-id CAGTBQpY+NQQmSxpi=c+T+JZEjYBrVNaiZ=_jExhTwix-o=T+PQ@mail.gmail.com
Whole thread Raw
In response to Re: pg_upgrade and materialized views  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pg_upgrade and materialized views
List pgsql-bugs
On Tue, Feb 20, 2018 at 7:08 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Claudio Freire <klaussfreire@gmail.com> writes:
>>> Looking into this I also saw:
>>> *      set_frozenxids()
>>> which makes a bit uncomfortable, but I can't quite put my finger on
>>> why.
>
>> I looked into that one, it's not relevant to this case, since it's
>> working on template1 (check the conn used there).
>
> Hm?  Looks to me like it iterates through all the DBs in the cluster.
>
>                         regards, tom lane

You're right. But IIUC it's called before restoring globals, so only
postgres, template0 and template1 exist at that point.


pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_upgrade and materialized views
Next
From: Andres Freund
Date:
Subject: Re: pg_upgrade and materialized views