MIME-Version: 1.0
References: <CA+FnnTx2Q=C-hUEBU08GMmfa0AGPt=XETnOW6G+=MyjrVmb7+Q@mail.gmail.com>
 <a167ec10588c4936c85327e1aa92b3d479cf5fa1.camel@cybertec.at>
In-Reply-To: <a167ec10588c4936c85327e1aa92b3d479cf5fa1.camel@cybertec.at>
From: Igor Korot <ikorot01@gmail.com>
Date: Mon, 10 Mar 2025 11:35:45 -0500
Message-ID: <CA+FnnTw0Q-DDusB9LVfQXYQer72Y8dZ3vxqv_1NMTqLCnH20hg@mail.gmail.com>
Subject: Re: Big script execution
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000ffdb8e062fff90dc"
Archived-At: <https://www.postgresql.org/message-id/CA%2BFnnTw0Q-DDusB9LVfQXYQer72Y8dZ3vxqv_1NMTqLCnH20hg%40mail.gmail.com>
Precedence: bulk

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

Hi, Laurenz,

On Mon, Mar 10, 2025, 11:31=E2=80=AFAM Laurenz Albe <laurenz.albe@cybertec.=
at>
wrote:

> On Mon, 2025-03-10 at 16:42 -0500, Igor Korot wrote:
> > I am trying to execute a huge script (~40K lines) that will populate
> > my database.
> >
> > The script starts with "BEGIN TRANSACTION" and will end
> > with "COMMIT".
> >
> > however I'd like to rollback if there is an error encounter.
> >
> > When I execute it from the Terminal I do use
> >
> > -v ON_ERROR_STOP=3D1
> >
> > but I'd like to rolback the transaction so it starts a fresh every time=
.
> >
> > Is there some kind of
> >
> > ON ERROR ROLLBACK
> >
> > command I can put inside the script?
>
> That happens automatically: if you are running the whole script in a
> single transaction, any error will make the whole transaction roll back.
>

Will the tables also be deleted?
The CREATE TABLE statements are part of this big transaction.

Thank you.


> Yours,
> Laurenz Albe
>

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

<div dir=3D"auto"><div>Hi, Laurenz,<br><br><div class=3D"gmail_quote gmail_=
quote_container"><div dir=3D"ltr" class=3D"gmail_attr">On Mon, Mar 10, 2025=
, 11:31=E2=80=AFAM Laurenz Albe &lt;<a href=3D"mailto:laurenz.albe@cybertec=
.at">laurenz.albe@cybertec.at</a>&gt; wrote:<br></div><blockquote class=3D"=
gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-=
left:1ex">On Mon, 2025-03-10 at 16:42 -0500, Igor Korot wrote:<br>
&gt; I am trying to execute a huge script (~40K lines) that will populate<b=
r>
&gt; my database.<br>
&gt; <br>
&gt; The script starts with &quot;BEGIN TRANSACTION&quot; and will end<br>
&gt; with &quot;COMMIT&quot;.<br>
&gt; <br>
&gt; however I&#39;d like to rollback if there is an error encounter.<br>
&gt; <br>
&gt; When I execute it from the Terminal I do use<br>
&gt; <br>
&gt; -v ON_ERROR_STOP=3D1<br>
&gt; <br>
&gt; but I&#39;d like to rolback the transaction so it starts a fresh every=
 time.<br>
&gt; <br>
&gt; Is there some kind of<br>
&gt; <br>
&gt; ON ERROR ROLLBACK<br>
&gt; <br>
&gt; command I can put inside the script?<br>
<br>
That happens automatically: if you are running the whole script in a<br>
single transaction, any error will make the whole transaction roll back.<br=
></blockquote></div></div><div dir=3D"auto"><br></div><div dir=3D"auto">Wil=
l the tables also be deleted?</div><div dir=3D"auto">The CREATE TABLE state=
ments are part of this big transaction.</div><div dir=3D"auto"><br></div><d=
iv dir=3D"auto">Thank you.</div><div dir=3D"auto"><br></div><div dir=3D"aut=
o"><div class=3D"gmail_quote gmail_quote_container"><blockquote class=3D"gm=
ail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-le=
ft:1ex">
<br>
Yours,<br>
Laurenz Albe<br>
</blockquote></div></div></div>

--000000000000ffdb8e062fff90dc--