Update provenance (PostgreSQL 14+)

Extended provenance tracking for INSERT, UPDATE, DELETE, and UNDO operations, including temporal validity ranges. More...

Types
TYPE	provsql.update_provenance
	Table recording the history of INSERT, UPDATE, DELETE, and UNDO operations. More...

Functions
TRIGGER	provsql.insert_statement_trigger ()
	Trigger function for INSERT statement provenance tracking.
TRIGGER	provsql.update_statement_trigger ()
	Trigger function for UPDATE statement provenance tracking.

Detailed Description

Extended provenance tracking for INSERT, UPDATE, DELETE, and UNDO operations, including temporal validity ranges.

Function Documentation

insert_statement_trigger()

TRIGGER provsql.insert_statement_trigger

(

)

Trigger function for INSERT statement provenance tracking.

Records the insertion in update_provenance and multiplies provenance tokens of inserted rows with the insert token.

Source code

provsql.sql line 1655

update_statement_trigger()

TRIGGER provsql.update_statement_trigger

(

)

Trigger function for UPDATE statement provenance tracking.

Records the update in update_provenance. Multiplies new-row tokens with the update token and applies monus to old-row tokens.

Source code

provsql.sql line 1702