DataGrip 2024.1 Help

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

Suppress an inspection in the editor

  1. Place the caret at the highlighted line and press Alt+Enter or click the Intention action icon.

  2. Click the arrow next to the inspection you want to suppress and select the necessary suppress action.

Last modified: 11 February 2024