Re: pg_dump and pg_restore and foreign keys

Поиск
Список
Период
Сортировка
От Tore Halvorsen
Тема Re: pg_dump and pg_restore and foreign keys
Дата
Msg-id CADGw-Sc1cFP3GaBhrXi9k+eoVHBmW0EQ-BRnOCsrFeRQNJvTGQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg_dump and pg_restore and foreign keys  (Tore Halvorsen <tore.halvorsen@gmail.com>)
Список pgsql-general
Дерево обсуждения
In case someone else needs to do this - I ended up with this change in pg_dump.c around lines 17080-17090

I guess a proper solution would check the already invalid foreign keys in a different way.

appendPQExpBuffer(q, "    ADD CONSTRAINT %s %s%s;\n",
fmtId(coninfo->dobj.name),
coninfo->condef
, dopt->foreign_keys_not_valid && !strstr(coninfo->condef, "NOT VALID") ? " NOT VALID":"");



On Wed, Oct 27, 2021 at 4:08 PM Tore Halvorsen <tore.halvorsen@gmail.com> wrote:
Then I'll try that, thank you :)

On Wed, Oct 27, 2021 at 4:04 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Tore Halvorsen <tore.halvorsen@gmail.com> writes:
> That would be appending it for "pg_catalog.pg_get_constraintdef(oid) AS
> condef"  in getConstraints in pg_dump.c?

No, you want to mess with the text printed by dumpConstraint().

                        regards, tom lane


--
Eld på åren og sol på eng gjer mannen fegen og fjåg. [Jøtul]
<demo> Tore Halvorsen || +052 0553034554


--
Eld på åren og sol på eng gjer mannen fegen og fjåg. [Jøtul]
<demo> Tore Halvorsen || +052 0553034554

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

Предыдущее
От: Kyotaro Horiguchi
Дата:
Сообщение: Re: WAL File Recovery on Standby Server Stops Before End of WAL Files
Следующее
От: "Peter J. Holzer"
Дата:
Сообщение: Re: Incremental backup