Re: Error handling: Resume work after error

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(at)depesz(dot)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
>
>