In this blog post, let’s learn about the error message “362 Can have only one column of serial/serial8 type.” in Hydra and the description of the error.
Error Message
362 Can have only one column of serial/serial8 type.
Error Details
A table can have at most only one column of type SERIAL and one column of type SERIAL8. You are attempting to add a second column of type SERIAL or SERIAL8, or you are attempting to create a table with more than one column of either type. If you intended to have a foreign key (that is, a column that refers to a SERIAL or SERIAL8 column in a different table), the data type of the column in this table should be
INTEGER or INTEGER8
Can have only one column of serial type.
Only one SERIAL column can exist in a table. This CREATE TABLE statement specifies two or more. Review the statement, and remove all but one of the columns with SERIAL data type. If you intended to have a foreign key (that is, a column that refers to a SERIAL column in a different table), the data type of the column in this table should be INTEGER.