On Thu, May 7, 2015 at 4:19 PM, Tom Lane <t...@sss.pgh.pa.us> wrote:

> Bruce Momjian <br...@momjian.us> writes:
> > On Thu, May  7, 2015 at 04:19:52PM -0400, Bruce Momjian wrote:
> >> Just a reality check but this will break a pg_upgrade, and will not be
> >> detected by --check.
>
> > Actually, pg_upgrade might be OK because the views would be recreated
> > with the new functions already installed.
>
> pg_upgrade is okay in any case because it dumps and reloads the current
> extension's components.  Doesn't matter whether there's another version
> that is not compatible.
>
>
​For clarity - which one is "current" in this context?

1. The existing database's (previous extension version)
2. The target database's (current default extension version in the new
PostgreSQL version)


​The answer has to be #2 since the version in the existing database no
longer exists in the new PostgreSQL version.

David J.
​

Reply via email to