Re: Moving to Postgresql database

On 1/16/24 00:06, Dominique Devienne wrote:
> On Mon, Jan 15, 2024 at 5:17 AM veem v <veema0000@gmail.com 
> <mailto:veema0000@gmail.com>> 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@aklaver.com