0.36.1 What version ofdrizzle-kitare you using? 0.28.0 Other packages No response Describe the Bug I am reporting this bug in the hopes that the docs will be updated as it results in countless issues. The Postgres docs still mention usingserial()as a datatype but this has been deprecated...
ALTER TABLE "some_entity" ALTER COLUMN "id" SET DATA TYPE serial; Full error: error: type "serial" does not exist at /Users/xxx/Code/xxx/node_modules/drizzle-kit/bin.cjs:43518:21 at process.processTicksAndRejections (node:internal/process/task_queues:95:5) at async PgPostgres.query (/...
flysand7 commented Apr 14, 2024 Using a custom type seems to work Doesn't work on latest drizzle. Any update on this issue?flysand7 mentioned this issue Apr 14, 2024 [FEATURE]: Add support for identity columns in postgres. #2108 Closed ...
const {Sequelize, DataTypes} = require('sequelize'); const sequelize = new Sequelize({dialect: "postgres", /* ... */}); // Connect to a fresh database const Model = sequelize.define("Model", {user_id: {type: DataTypes.INTEGER, primaryKey: true, autoIncrement: true, allowNull: false...
Generate the migration:ALTER TABLE "users" ALTER COLUMN "id" SET DATA TYPE serial;--> statement-breakpointRun the migrationThe following error occursPostgresError: type "serial" does not existExpected behaviorThe migration is successfulEnvironment & setupLinux, posgres 14...