Re: Error handling: Resume work after error - Mailing list pgsql-general

From Raul Kaubi
Subject Re: Error handling: Resume work after error
Date
Msg-id CAO_+3-AV_UjU78XaEXJek_pAa9Fp-KuBASsd-3R__feWnXq1qg@mail.gmail.com
Whole thread Raw
In response to Re: Error handling: Resume work after error  (hubert depesz lubaczewski <depesz@depesz.com>)
List pgsql-general
Oh yeah, I must add new begin ... exception .. end; block between.

So like this:

BEGIN
 
BEGIN
EXCEPTION when ..... then ..
END;

END;

At first I did like this:

BEGIN
..... 
EXCEPTION when ..... then ..;
END;  

Raul

Kontakt hubert depesz lubaczewski (<depesz@depesz.com>) kirjutas kuupäeval K, 5. veebruar 2020 kell 17:03:
On Wed, Feb 05, 2020 at 04:17:09PM +0200, Raul Kaubi wrote:
> Let's say I want my procedure/function to resume work after specific error
> ( duplicate_table ).
> Is it possible to resume work after error..?
> EXCEPTION
> > WHEN duplicate_table then ......;

Sure you can:

https://www.postgresql.org/docs/current/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING

Best regards,

depesz

pgsql-general by date:

Previous
From: Олег Самойлов
Date:
Subject: Re: initialize and use variable in query
Next
From: Adrian Klaver
Date:
Subject: Re: Restore is failing