MIME-Version: 1.0
References: <7da8ec9-089-74ce-eb3-c88889b62c64@appl-ecosys.com>
 <CANzqJaAXnwh-n0K_JhGiGja2vdqFvRvffdwe2RkVAVKLbmH69g@mail.gmail.com> <CAKFQuwbGedOO=iq9uC1e7FEbURvuFh1CHXrEZ-uF1mSt2+scyQ@mail.gmail.com>
In-Reply-To: <CAKFQuwbGedOO=iq9uC1e7FEbURvuFh1CHXrEZ-uF1mSt2+scyQ@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Tue, 11 Jun 2024 00:40:11 -0400
Message-ID: <CANzqJaDkSP3=gr7FGxBCHmG6g9hfx=sDha0M52RK8hxRm911+A@mail.gmail.com>
Subject: Re: Multiple tables row insertions from single psql input file
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000001e31c9061a95dd4d"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaDkSP3%3Dgr7FGxBCHmG6g9hfx%3DsDha0M52RK8hxRm911%2BA%40mail.gmail.com>
Precedence: bulk

--0000000000001e31c9061a95dd4d
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Mon, Jun 10, 2024 at 5:16=E2=80=AFPM David G. Johnston <
david.g.johnston@gmail.com> wrote:

> On Mon, Jun 10, 2024 at 12:43=E2=80=AFPM 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 "ALTE=
R
>> 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.

--0000000000001e31c9061a95dd4d
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Mon, Jun 10, 2024 at 5:16=E2=80=AFPM D=
avid G. Johnston &lt;<a href=3D"mailto:david.g.johnston@gmail.com">david.g.=
johnston@gmail.com</a>&gt; wrote:<br></div><div class=3D"gmail_quote"><bloc=
kquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:=
1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div class=3D=
"gmail_quote"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px=
 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><span class=
=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif"></span>=
On Mon, Jun 10, 2024 at 12:43=E2=80=AFPM Ron Johnson &lt;<a href=3D"mailto:=
ronljohnsonjr@gmail.com" target=3D"_blank">ronljohnsonjr@gmail.com</a>&gt; =
wrote:</blockquote><blockquote class=3D"gmail_quote" style=3D"margin:0px 0p=
x 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div d=
ir=3D"ltr"><div dir=3D"ltr"><br></div><div class=3D"gmail_quote"><div>Most =
useful to you will be some number of &quot;<font face=3D"monospace">ALTER T=
ABLE &lt;foo&gt; DISABLE TRIGGER ALL;</font>&quot; statements near the begi=
nning of the file, and their &quot;<font face=3D"monospace">ALTER TABLE ...=
 ENABLE TRIGGER ALL;</font>&quot; counterparts near the end of the file.</d=
iv><div><br></div></div></div></blockquote><div><br></div><div style=3D"fon=
t-family:arial,helvetica,sans-serif">Have you just not heard of deferred co=
nstraints or is there some reason besides=C2=A0deferring constraints that y=
ou&#39;d want to use alter table in transactional production code?</div></d=
iv></div></blockquote><div><br></div><div>I mentioned bulk loading of data.=
=C2=A0 Occasionally that&#39;s useful, even in a prod database.</div><div>=
=C2=A0<br></div></div></div>

--0000000000001e31c9061a95dd4d--