In this blog post, let’s learn about the error message “234 Cannot insert into virtual column column-name.” in Hydra and the description of the error.
Error Message
234 Cannot insert into virtual column column-name.
Error Details
You cannot alter the contents of a column with the SERIAL data type in the UPDATE statement, even when the updating value is zero. (You can specify a value of zero for a serial column when you use the INSERT statement; the database server ignores the zero and inserts a generated number.) Revise the statement so that only nonserial columns are updated.