Re: Multiple tables row insertions from single psql input file

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Multiple tables row insertions from single psql input file
Дата
Msg-id CANzqJaDkSP3=gr7FGxBCHmG6g9hfx=sDha0M52RK8hxRm911+A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Multiple tables row insertions from single psql input file  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-general
Дерево обсуждения
On Mon, Jun 10, 2024 at 5:16 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
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?

I mentioned bulk loading of data.  Occasionally that's useful, even in a prod database.
 

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

Предыдущее
От: Kashif Zeeshan
Дата:
Сообщение: Re: Vacuum backend with backend_xmin?
Следующее
От: "Shenavai, Manuel"
Дата:
Сообщение: autoanalyze / autovacuum vs manually executed "vacuum analyze"