thank you Luis, but this is not supported in plpgsql
--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
- Mensagem original -
> Any idea how to approach it?
Hi!
https://www.postgresql.org/docs/current/sql-savepoint.html
Luis R. Weck
Hi,
i need to emulate oracle's savepoint behaviour inside of the plpgsql
function.
This function is able to insert all the rows that weren't caught on the
exception, but i need also to rollback the insert that happens before the
exception.
So let's say the exception is thrown when j=3 so i need a