Re: Resurrecting pg_upgrade - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Resurrecting pg_upgrade
Date
Msg-id 5203.1071456500@sss.pgh.pa.us
Whole thread Raw
In response to Re: Resurrecting pg_upgrade  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Responses Re: Resurrecting pg_upgrade  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List pgsql-hackers
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
> What about cached OIDs in view and function definitions, etc...?

Doesn't matter.  Catalog entries are dumped and reloaded; there is no
carry-forward of OIDs.

I suppose if someone were storing OIDs of tables or functions or views
in user tables, this procedure would break the references.  But that
would be true of a dump/reload under current procedures as well.  I'm
willing to say that that's unsupported.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Neil Conway
Date:
Subject: Re: ORDER BY and DISTINCT ON
Next
From: Bruno Wolff III
Date:
Subject: Re: ORDER BY and DISTINCT ON