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 по дате отправления: