HELP: SAVEPOINT feature cases

Started by itumonohito9 months ago3 messages
#1itumonohito
itumonohito@gmail.com

Dear hackers,

I hope this email finds you well.

I am writing to inquire about the use cases for the SAVEPOINT feature.

I would appreciate it if you could provide some examples of scenarios where
this functionality proves particularly useful.

Thank you for your time and assistance. I look forward to your response.

Sincerely,

jack.

#2Kirill Reshke
reshkekirill@gmail.com
In reply to: itumonohito (#1)
Re: HELP: SAVEPOINT feature cases

On Mon, 14 Apr 2025 at 21:54, itumonohito <itumonohito@gmail.com> wrote:

Dear hackers,

I hope this email finds you well.

I am writing to inquire about the use cases for the SAVEPOINT feature.

I would appreciate it if you could provide some examples of scenarios where this functionality proves particularly useful.

Thank you for your time and assistance. I look forward to your response.

Sincerely,

jack.

Have you read https://www.postgresql.org/docs/current/sql-savepoint.html
? There are a few examples here.

--
Best regards,
Kirill Reshke

#3Greg Sabino Mullane
htamfids@gmail.com
In reply to: itumonohito (#1)
Re: HELP: SAVEPOINT feature cases

I am writing to inquire about the use cases for the SAVEPOINT feature.

Savepoints are used to implement ON_ERROR_ROLLBACK in psql. See:

https://www.endpointdev.com/blog/2015/02/postgres-onerrorrollback-explained/

Cheers,
Greg

--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support