Breaking News: Grepper is joining You.com. Read the official announcement!

SequelizeDatabaseError: syntax error at or near "SERIAL"

Badie96 answered on April 18, 2023 Popularity 3/10 Helpfulness 2/10

answer SequelizeDatabaseError: syntax error at or near "SERIAL"

SequelizeDatabaseError: syntax error at or near "SERIAL"

Comment

// If you are assigning autoincrement to non sequential column like "UUID",
// this issue can occur.
// It is not the right way to assign autoincrement to non sequential column.
// Use default instead (generate UUID v4):

field_name: {
    type: DataTypes.UUID,
    allowNull: false,
    primaryKey: true,
    default: sequelize.fn('uuid_generate_v4')
}

Popularity 3/10 Helpfulness 2/10 Language typescript

Source: stackoverflow.com

Tags: near syntax-error whatever

Link to this answer
Share Copy Link