Stored procedures also support the atomicity of object updates. If an operation is canceled, all intermediate data is deleted, and updates of metadata tables are not committed.

Even if procedures update pgpro_metastore objects in one transaction, additional service transactions are committed to log data updates. Logs allow canceling updates when the server fails or reloads. You can do this by executing the following command:

  SELECT metastore.cleanup();

Required privileges: Postgres Pro AXE administrator only. For more information about stored procedures and privileges, refer to Section 22.1.