Re: BUG #15183: pg_upgrade and pg_upgrade.exe both corrupt sequences when migrating 9.1 10.3

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #15183: pg_upgrade and pg_upgrade.exe both corrupt sequences when migrating 9.1 10.3
Дата
Msg-id 18109.1525272429@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #15183: pg_upgrade and pg_upgrade.exe both corrupt sequences whenmigrating 9.1 10.3  (PG Bug reporting form <noreply@postgresql.org>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #15180: Alter table add column if not exists with unique constraint will add extra duplicate
Следующее
От:
Дата:
Сообщение: postgresql license question