Code Inspection: Insertion into generated columns

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

Example (PostgreSQL):

CREATE TABLE foo
(
   col1 INT,
   col2 INT GENERATED ALWAYS AS (col1 + 1) STORED
);
INSERT INTO foo(col1, col2) VALUES (1, 2);

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);

Place the caret at the highlighted line and press Alt+Enter or click .
Click the arrow next to the inspection you want to suppress and select the necessary suppress action.

Last modified: 11 February 2024