On 1/16/24 00:06, Dominique Devienne wrote:
On Mon, Jan 15, 2024 at 5:17 AM veem v <veema0000@xxxxxxxxx
<mailto:veema0000@xxxxxxxxx>> wrote:
Is any key design/architectural changes should the app development
team [...], should really aware about
Hi. One of the biggest pitfall of PostgreSQL, from the app-dev perspective,
is the fact any failed statement fails the whole transaction, with
ROLLBACK as the only recourse.
https://www.postgresql.org/docs/current/sql-savepoint.html
"SAVEPOINT establishes a new savepoint within the current transaction.
A savepoint is a special mark inside a transaction that allows all
commands that are executed after it was established to be rolled back,
restoring the transaction state to what it was at the time of the
savepoint."
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
