Hi, Laurenz,
On Mon, Mar 10, 2025, 11:31 AM Laurenz Albe <laurenz.albe@xxxxxxxxxxx> 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_=1
>
> 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
