Inspectopedia
 
2024.3

Insertion into generated columns

Warning
New
Last modified: 03 December 2024

Reports INSERT statements that assign values to generated columns. Generated columns can be read, but their values can not be directly written.

Example (PostgreSQL):

You cannot insert 2 into the col2 column because this column is generated. For this script to work, you can change 2 to DEFAULT.

INSERT INTO foo(col1, col2) VALUES (1, DEFAULT);