Savepoints

Chapman Flack edited this page Dec 22, 2015 · 2 revisions

Savepoints

PostgreSQL savepoints are exposed using the standard setSavepoint() and releaseSavepoint() methods on the java.sql.Connection interface. Two restrictions apply:

  • A savepoint must be rolled back or released in the function where it was set.
  • A savepoint must not outlive the function where it was set.

"Function" here refers to the PL/Java function that is called from SQL. The restrictions do not prevent the Java code from being organized into several methods, but the savepoint cannot survive the eventual return from Java to the SQL caller.

You can’t perform that action at this time.
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session.
Press h to open a hovercard with more details.