MIME-Version: 1.0
References: <b77e58b-dd8c-373b-2a25-9eb224488e8b@appl-ecosys.com>
 <65F95FD4-CBEA-4E66-AE63-EBC9F617C988@gmail.com> <7678da90-521-3b52-4bb5-11bc9bdf6d1@appl-ecosys.com>
 <CANzqJaDFgsgyvG7y8Y6SOEFSJTrvmMT3mZz=5QiRfU7T1Muayg@mail.gmail.com> <65e3d37-1674-97c9-9010-2196384b851@appl-ecosys.com>
In-Reply-To: <65e3d37-1674-97c9-9010-2196384b851@appl-ecosys.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Wed, 19 Jun 2024 17:44:30 -0400
Message-ID: <CANzqJaAWLCZt0uWBSUWUDtgAsgFnuKjbDRSQgguWQQN55O=DWw@mail.gmail.com>
Subject: Re: Transaction issue
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000002367f7061b451b64"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaAWLCZt0uWBSUWUDtgAsgFnuKjbDRSQgguWQQN55O%3DDWw%40mail.gmail.com>
Precedence: bulk

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

On Wed, Jun 19, 2024 at 5:39=E2=80=AFPM Rich Shepard <rshepard@appl-ecosys.=
com>
wrote:

> On Wed, 19 Jun 2024, Ron Johnson wrote:
>
> > The problem is that you don't know where it's failing.
>
> Ron,
>
> True that. There's no specificity to why the transaction didn't complete.
>
> > I suggest you run "\echo all"  before running "\i
> > insert-law-offices-addr.sql".  That way, you'll see which line it barfs
> on.
>
> Good point. I'll do that. In the meantime, commenting out (or removing) t=
he
> BEGIN; command inserts all rows without error.
>
>
In addition, manually run the "BEGIN;" before the "\i insert-blarge.sql"
command.

That way, insert-blarge.sql just inserts.  My reasoning: since you control
the ROLLBACK, you should also control the BEGIN.

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

<div dir=3D"ltr"><div dir=3D"ltr">On Wed, Jun 19, 2024 at 5:39=E2=80=AFPM R=
ich Shepard &lt;<a href=3D"mailto:rshepard@appl-ecosys.com">rshepard@appl-e=
cosys.com</a>&gt; wrote:<br></div><div class=3D"gmail_quote"><blockquote cl=
ass=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid=
 rgb(204,204,204);padding-left:1ex">On Wed, 19 Jun 2024, Ron Johnson wrote:=
<br>
<br>
&gt; The problem is that you don&#39;t know where it&#39;s failing.<br>
<br>
Ron,<br>
<br>
True that. There&#39;s no specificity to why the transaction didn&#39;t com=
plete.<br>
<br>
&gt; I suggest you run &quot;\echo all&quot;=C2=A0 before running &quot;\i<=
br>
&gt; insert-law-offices-addr.sql&quot;.=C2=A0 That way, you&#39;ll see whic=
h line it barfs on.<br>
<br>
Good point. I&#39;ll do that. In the meantime, commenting out (or removing)=
 the<br>
BEGIN; command inserts all rows without error.<br><br></blockquote><div><br=
></div><div>In addition, manually run the &quot;BEGIN;&quot; before the &qu=
ot;\i insert-blarge.sql&quot; command.</div><div><br></div><div>That way, i=
nsert-blarge.sql just inserts.=C2=A0 My reasoning: since you control the RO=
LLBACK, you should also control the BEGIN.</div><div><br></div></div></div>

--0000000000002367f7061b451b64--