BUG #17732: pg_restore fails with check constraint

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема BUG #17732: pg_restore fails with check constraint
Дата
Msg-id CAKFQuwbhscV_3y+PU2dkBa-=rm7wyGLiKnKz8ZvG7xrLb4pUAQ@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #17732: pg_restore fails with check constraint  (PG Bug reporting form <noreply@postgresql.org>)
Список pgsql-bugs
Дерево обсуждения
On Tuesday, December 27, 2022, PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      17732
Logged by:          Artem
Email address:      artem.voropaev@hotmail.com
PostgreSQL version: 13.9
Operating system:   Debian
Description:       

Hi team! We faced an error using pg_restore on our database. We have
database tables like this one:

Is there any solution for this specific problem?


Unbreak the source system by converting the check constraint into a trigger.  Check constraints, as documented, must be immutable.  Unfortunately the system doesn’t warn you when you’ve violated this rule upfront.

David J.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #17733: ERROR: could not load library "/Users/frank/postgres/postgresql-13.9/lib/postgresql/llvmjit.so": dl
Следующее
От: Justin Pryzby
Дата:
Сообщение: Re: BUG #17717: Regression in vacuumdb (15 is slower than 10/11 and possible memory issue)