Re: BUG #15183: pg_upgrade and pg_upgrade.exe both corrupt sequences when migrating 9.1 10.3 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #15183: pg_upgrade and pg_upgrade.exe both corrupt sequences when migrating 9.1 10.3
Date
Msg-id 18109.1525272429@sss.pgh.pa.us
Whole thread Raw
In response to BUG #15183: pg_upgrade and pg_upgrade.exe both corrupt sequences whenmigrating 9.1 10.3  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
=?utf-8?q?PG_Bug_reporting_form?= <noreply@postgresql.org> writes:
> On the most recent version, after the pg_upgrade ran, we were unable to
> insert records.  Analysis showed that our normally very simple sequences had
> multiple dependencies attached to them (in the 10.3 database).  The 9.1
> database only had a single dependency on the sequence.  The pattern of which
> dependencies were added to which sequences was not discernible, but it was
> the same on both Windows and Linux.

You haven't really provided enough information to let anyone else
reproduce or investigate this.  What do you mean by "multiple dependencies
attached"?  How would that have broken your application?  What exactly
is the database schema that pg_upgrade failed to reproduce accurately?

Ideally, what I'd like to have to avoid wasting time reverse-engineering
your problem is a SQL script that creates a 9.1 database that pg_upgrade
will then fail on.

            regards, tom lane


pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #15180: Alter table add column if not exists with unique constraint will add extra duplicate
Next
From:
Date:
Subject: postgresql license question