Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [savepoint]

Use the savepoint tag to denote questions concerning nested transactions.

Filter by
Sorted by
Tagged with
0 votes
1 answer
175 views

PostgreSQL driven by SQLAlchemy - Release Savepoint Idle in Transaction

While running PostgreSQL 13.12 (occurs in several versions of PG11/PG13) using SQLAlchemy 1.3, we are occasionally hitting issues where increased concurrency leaves certain transactions (and their ...
Justin Lowen's user avatar
0 votes
1 answer
1k views

syntax error at or near TO (ROLLBACK TO SAVEPOINT)

The following sql is a part from a FUNCTION ,i want to rollback to rbk SAVEPOINT : for ptrEnt in entite loop -- positionnement du point de retour pour une entité savepoint rbk; -...
unknownUser's user avatar
0 votes
2 answers
3k views

ROLLBACK TO SAVEPOINT syntax error at or near "TO"

I am having trouble in executing the following FUNCTION in PostgreSQL CREATE OR REPLACE FUNCTION pckg_fcvoi.supprimer_voies_plus_42c (CodeEntite text) RETURNS VOID AS $body$ DECLARE ...
unknownUser's user avatar
0 votes
1 answer
964 views

How to gracefully handle MySQL deadlocks involving SAVEPOINT?

I have a concurrency problem where 2 (or more) processes are making inserts at the same time and are all locking the same index page (I guess) among with a on a SELECT FOR UPDATE clause Here is a ...
Romuald Brunet's user avatar
2 votes
2 answers
1k views

Do Nested Transactions commit? [closed]

I am not happy with the Wikipedia article about nested transactions. I would not use the word "commit" for a nested transaction. For me "commit" means "durability". A nested transaction does not ...
guettli's user avatar
  • 1,521
1 vote
1 answer
427 views

SQLAnywhere: Savepoint for ROLLBACK not found

What is the correct way on setting and rolling back to savepoint on SQLAnywhere. Having this snippet: begin transaction; SAVEPOINT spt_abc; insert into eins (pl1) values (5); SAVEPOINT spt_123; ...
frlan's user avatar
  • 495