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)
Do remember that
force: true
will drop your tables each time!