Re: pg_upgrade 9.6->9.6: column "amtype" does not exist

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc: Christoph Berg <myon(at)debian(dot)org>, Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>, Petr Jelinek <petr(at)2ndquadrant(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pg_upgrade 9.6->9.6: column "amtype" does not exist
Date: 2016-04-01 21:55:58
Message-ID: 584.1459547758@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Alvaro Herrera <alvherre(at)2ndquadrant(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim Nasby 2016-04-01 22:22:59 Re: syntax sugar for conditional check
Previous Message Alvaro Herrera 2016-04-01 21:39:01 Re: pg_upgrade 9.6->9.6: column "amtype" does not exist