Re: Multiple tables row insertions from single psql input file - Mailing list pgsql-general

From Ron Johnson
Subject Re: Multiple tables row insertions from single psql input file
Date
Msg-id CANzqJaDkSP3=gr7FGxBCHmG6g9hfx=sDha0M52RK8hxRm911+A@mail.gmail.com
Whole thread Raw
In response to Re: Multiple tables row insertions from single psql input file  ("David G. Johnston" <david.g.johnston@gmail.com>)
List 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 by date:

Previous
From: Kashif Zeeshan
Date:
Subject: Re: Vacuum backend with backend_xmin?
Next
From: "Shenavai, Manuel"
Date:
Subject: autoanalyze / autovacuum vs manually executed "vacuum analyze"