Module generated_values 

PostgreSQL rules for the values a statement writes to the columns whose values a table generates: identity columns and generated columns.

Structs

GeneratedValueColumns

The identity and generated columns of one table, in column order, read once for a statement that writes it. PostgreSQL applies these rules when it rewrites the statement, column by column in table order, before it reads or writes a row, so a statement whose source yields no row is rejected as well.

Functions

generated_always_insert_error

The 428C9 error of a value an INSERT supplies for a GENERATED ALWAYS identity column.

generated_always_update_error

The 428C9 error of an assignment other than DEFAULT to a GENERATED ALWAYS identity column.

generated_column_insert_error

The 428C9 error of a value an INSERT supplies for a generated column.

generated_column_update_error

The 428C9 error of an assignment other than DEFAULT to a generated column.

stored_columns_for_update

Stored expressions affected by an UPDATE’s target columns. Explicitly assigning an unchanged input still selects its dependents; assigning a generated column to DEFAULT does not select it by itself. Callers with BEFORE ROW UPDATE triggers must recompute every stored expression instead.