public inbox for [email protected]  

help / color / mirror / Atom feed

From: David G. Johnston <[email protected]>
To: Ron Johnson <[email protected]>
Cc: pgsql-generallists.postgresql.org <[email protected]>
Subject: Re: Multiple tables row insertions from single psql input file
Date: Mon, 10 Jun 2024 14:15:36 -0700
Message-ID: <CAKFQuwbGedOO=iq9uC1e7FEbURvuFh1CHXrEZ-uF1mSt2+scyQ@mail.gmail.com> (raw)
In-Reply-To: <CANzqJaAXnwh-n0K_JhGiGja2vdqFvRvffdwe2RkVAVKLbmH69g@mail.gmail.com>
References: <[email protected]>
	<CANzqJaAXnwh-n0K_JhGiGja2vdqFvRvffdwe2RkVAVKLbmH69g@mail.gmail.com>

>
> On Mon, Jun 10, 2024 at 12:43 PM Ron Johnson <[email protected]>
> 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.

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Multiple tables row insertions from single psql input file
  In-Reply-To: <CAKFQuwbGedOO=iq9uC1e7FEbURvuFh1CHXrEZ-uF1mSt2+scyQ@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox