sequelize: Unhandled rejection SequelizeDatabaseError: type "enum_templates_type" already exists on PostgreSql

With every sync, sequelize tries to create a type Executing (default): CREATE TYPE “enum_templates_type” AS ENUM(‘TEMPLATE’, ‘FRAGMENT’); which fails with:

Unhandled rejection SequelizeDatabaseError: type “enum_templates_type” already exists at Query.formatError (~node_modules/sequelize/lib/dialects/postgres/query.js:423:14) at null.<anonymous> ~node_modules/sequelize/lib/dialects/postgres/query.js:104:19) at EventEmitter.emit (events.js:95:17) at Query.handleError (~node_modules/pg/lib/query.js:99:8) at null.<anonymous> (~node_modules/pg/lib/client.js:163:26) at EventEmitter.emit (events.js:95:17) at Socket.<anonymous> (~node_modules/pg/lib/connection.js:109:12) at Socket.EventEmitter.emit (events.js:95:17)

My model looks like: var Template = sequelize.define(“template”,

    {
        id: {
            type: DataTypes.UUID,
            primaryKey: true,
            defaultValue: DataTypes.UUIDV4,
            allowNull: false
        },

        type: {
            type: DataTypes.ENUM('TEMPLATE','FRAGMENT')
        }

});

About this issue

  • Original URL
  • State: closed
  • Created 9 years ago
  • Comments: 17 (9 by maintainers)

Most upvoted comments

Do remember that force: true will drop your tables each time!