Postgres Pro
Downloads
Home   >   mailing lists

Re: Problems with pg_upgrade and extensions referencing catalogtables/views - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Problems with pg_upgrade and extensions referencing catalogtables/views
Date
Msg-id 20190510001407.xqfihagkglgjrrip@momjian.us
Whole thread Raw
In response to Problems with pg_upgrade and extensions referencing catalogtables/views  ("Nasby, Jim" <nasbyj@amazon.com>)
Responses Re: Problems with pg_upgrade and extensions referencing catalogtables/views  ("Nasby, Jim" <nasbyj@amazon.com>)
List pgsql-hackers
Tree view 
On Wed, May  8, 2019 at 10:07:23PM +0000, Nasby, Jim wrote:
> I don’t recall why pg_upgrade wants to control OIDs… don’t we
> re-create all catalog entries for user objects from scratch?

The C comment at top of pg_upgrade.c explains why some oids must be preserved:


https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/bin/pg_upgrade/pg_upgrade.c;h=0b304bbd56ab0204396838618e86dfad757c2812;hb=HEAD

It doesn't mention extensions.

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +

pgsql-hackers by date:

Previous
From: Justin Pryzby
Date:
Subject: Re: pg12 release notes
Next
From: Justin Pryzby
Date:
Subject: Re: pg12 release notes