Re: pg_upgrade 9.6->9.6: column "amtype" does not exist - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_upgrade 9.6->9.6: column "amtype" does not exist
Date
Msg-id 584.1459547758@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_upgrade 9.6->9.6: column "amtype" does not exist  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: pg_upgrade 9.6->9.6: column "amtype" does not exist  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
Alvaro Herrera <alvherre@2ndquadrant.com> writes:
> The reason for the failure is that pg_dump knows that 9.6 installations
> have the amtype column -- but on your older devel 9.6 install, it
> doesn't exist.  To fix it we would have to compare catalog versions in
> pg_dump rather than major version, but we don't that anywhere.  Anyway
> many upgrades could fail depending on other patches because of the same
> reason.  I don't think we need to fix this.

We've never expected pg_dump to be able to handle intermediate development
versions.  It's enough of a maintenance burden that it knows how to dump
from all previous stable branches.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: pg_upgrade 9.6->9.6: column "amtype" does not exist
Next
From: Jim Nasby
Date:
Subject: Re: syntax sugar for conditional check