Обсуждение: Error handling: Resume work after error
Hi
PostgreSQL 12.1
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 ......;
Or is there different approach to achieve that..?
Thanks
Raul
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
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