Re: Multiple tables row insertions from single psql input file

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Multiple tables row insertions from single psql input file
Дата
Msg-id CAKFQuwbGedOO=iq9uC1e7FEbURvuFh1CHXrEZ-uF1mSt2+scyQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Multiple tables row insertions from single psql input file  (Ron Johnson <ronljohnsonjr@gmail.com>)
Ответы Re: Multiple tables row insertions from single psql input file
Список pgsql-general
Дерево обсуждения
On Mon, Jun 10, 2024 at 12:43 PM Ron Johnson <ronljohnsonjr@gmail.com> wrote:

Most useful to you will be some number of "ALTER TABLE <foo> DISABLE TRIGGER ALL;" statements near the beginning of the file, and their "ALTER TABLE ... ENABLE TRIGGER ALL;" counterparts near the end of the file.


Have you just not heard of deferred constraints or is there some reason besides deferring constraints that you'd want to use alter table in transactional production code?

David J.

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Escaping single quotes with backslash seems not to work
Следующее
От: "Peter J. Holzer"
Дата:
Сообщение: Re: Multiple tables row insertions from single psql input file