Column Not Allowed Error While Inserting Rows Using Sequence Values

I've already successfully created a Sequence for the criminal_id column in the criminals table, but when I try to insert a new row, I get a 'column not allowed' error. Here's the s

Solution 1:

You missed some quotes, otherwise it thought those unquoted are column names, thus that error message:

INSERT INTO criminals (criminal_id, last, first)
VALUES (criminals_criminal_id_seq.NEXTVAL, 'Capps', 'Johnny');