pg-mem
pg-mem copied to clipboard
oguimbal
creating an ENUM type, pg-mem throws an unexpected error
When running a Sequelize migration that involves creating an ENUM type, pg-mem throws an unexpected error:
Migration failed: Error:
at Query.run (/Users/qaisar.irfan/Documents/nestjs-sequelize-pg-mem/node_modules/sequelize/src/dialects/postgres/query.js:76:25)
at /Users/qaisar.irfan/Documents/nestjs-sequelize-pg-mem/node_modules/sequelize/src/sequelize.js:650:28
at async Promise.all (index 0)
at PostgresQueryInterface.ensureEnums (/Users/qaisar.irfan/Documents/nestjs-sequelize-pg-mem/node_modules/sequelize/src/dialects/postgres/query-interface.js:47:21)
at PostgresQueryInterface.createTable (/Users/qaisar.irfan/Documents/nestjs-sequelize-pg-mem/node_modules/sequelize/src/dialects/abstract/query-interface.js:210:5)
at Object.up (/Users/qaisar.irfan/Documents/nestjs-sequelize-pg-mem/migrations/20250203115647-create-users.js:9:5)
at usersMigration (/Users/qaisar.irfan/Documents/nestjs-sequelize-pg-mem/test/test-utils.ts:126:7)
at Object.<anonymous> (/Users/qaisar.irfan/Documents/nestjs-sequelize-pg-mem/src/user/user.service.spec.ts:32:5) {
name: 'SequelizeDatabaseError',
parent: TypeError: Cannot read properties of null (reading 'Symbol()')
*️⃣ Failed SQL statement: SELECT t.typname enum_name, array_agg(e.enumlabel ORDER BY enumsortorder) enum_value FROM pg_type t JOIN pg_enum e ON t.oid = e.enumtypid JOIN pg_catalog.pg_namespace n ON n.oid = t.typnamespace WHERE n.nspname = 'public' AND t.typname='enum_Users_role' GROUP BY 1;
To Reproduce
Run a Sequelize migration that attempts to create a table with an ENUM column. The error occurs when querying pg_type and pg_enum.
SELECT t.typname enum_name, array_agg(e.enumlabel ORDER BY enumsortorder) enum_value
FROM pg_type t
JOIN pg_enum e ON t.oid = e.enumtypid
JOIN pg_catalog.pg_namespace n ON n.oid = t.typnamespace
WHERE n.nspname = 'public' AND t.typname='enum_Users_role'
GROUP BY 1;
This query fails in pg-mem, but succeeds in a real PostgreSQL database.
pg-mem version
"version": "3.0.5",
