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>
 <bfcc535f-403c-4ce4-b096-c93da5b0f1b6@aklaver.com> <ad52f862-63b4-fd42-bbce-33991b5e0bb@appl-ecosys.com>
In-Reply-To: <ad52f862-63b4-fd42-bbce-33991b5e0bb@appl-ecosys.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Wed, 19 Jun 2024 17:02:19 -0400
Message-ID: <CANzqJaCtycs55AXMtY+eVGLoEeARKKUq_7qVPJXyTuM2hi45Cg@mail.gmail.com>
Subject: Re: Transaction issue
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000034b29a061b448448"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaCtycs55AXMtY%2BeVGLoEeARKKUq_7qVPJXyTuM2hi45Cg%40mail.gmail.com>
Precedence: bulk

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

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

> On Wed, 19 Jun 2024, Adrian Klaver wrote:
>
> > Looks to me you have a left over unresolved transaction in your psql
> session.
> > The easiest solution if that is the case is to exit the session and
> start a
> > new session to run the script.
>
> Adrian, et al.:
>
> That's what I've done. This time I commented out the BEGIN; line:
> bustrac=3D# \i insert-law-offices-addr.sql
> INSERT 0 66
>
> There are no errors in the file but when I tried running it as a
> transaction
> it failed.
>
> I have not before used transactions when inserting or updating tables; I'=
m
> surprised that starting the transaction from the psql command line chokes
> the attempt.
>

It doesn't.  The rest of us have successfully done it before.  You're Doing
*Something* Wrong.  Don't know what, but you're doing it. Happens to *ALL
OF US*, and is why "\echo all" and "psql -a" were developed.

So we can see WTH we screwed up, and then fix it.

--00000000000034b29a061b448448
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 4:54=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, Adrian Klaver wrot=
e:<br>
<br>
&gt; Looks to me you have a left over unresolved transaction in your psql s=
ession. <br>
&gt; The easiest solution if that is the case is to exit the session and st=
art a <br>
&gt; new session to run the script.<br>
<br>
Adrian, et al.:<br>
<br>
That&#39;s what I&#39;ve done. This time I commented out the BEGIN; line:<b=
r>
bustrac=3D# \i insert-law-offices-addr.sql <br>
INSERT 0 66<br>
<br>
There are no errors in the file but when I tried running it as a transactio=
n<br>
it failed.<br>
<br>
I have not before used transactions when inserting or updating tables; I=
9;m<br>
surprised that starting the transaction from the psql command line chokes<b=
r>
the attempt.<br></blockquote><div>=C2=A0</div><div>It doesn&#39;t.=C2=A0 Th=
e rest of us have successfully done it before.=C2=A0 You&#39;re Doing <i>So=
mething</i>=C2=A0Wrong.=C2=A0 Don&#39;t know what, but you&#39;re doing it.=
 Happens to <b>ALL OF US</b>, and is why &quot;<font face=3D"monospace">\ec=
ho all</font>&quot; and &quot;<font face=3D"monospace">psql -a</font>&quot;=
 were developed.</div><div><br></div><div>So we can see WTH=C2=A0we screwed=
 up, and then fix it.</div><div><br></div></div></div>

--00000000000034b29a061b448448--