[BUG]:[Postgres][Migrations] Fails in this snippet text('').array(); about drizzle-orm

[vats-24]

Thanks @realmikesolo i got it it was the problem with imports

[realmikesolo]

Hello, @vats-24! Could you please check if you use text type from drizzle-orm/pg-core, because you might import it from drizzle-orm/mysql-core

[vats-24]

@realmikesolo No, I've checked i'm importing it from drizzle-orm/pg-core but when importing i am not getting any inference/recommendation from the editior of array member neither from drizzle-orm/pg-core nor from drizzle-orm/mysql-core. I think they have removed it but it's not mentioned in the docs.

[realmikesolo]

@vats-24 could you please show your schema?

[vats-24]

@realmikesolo yeah sure this is my schema below:-

export const roles = pgTable(
"roles",
{
id: uuid("id").defaultRandom().notNull(),
name: varchar("name", { length: 256 }).notNull(),
applicationId: uuid("applicationId").references(() => application.id),
permissions: text("permissions").array().$type<Array>(), // here i'm facing the problem
createdAt: timestamp("created_at").defaultNow().notNull(),
updatedAt: timestamp("updated_at").defaultNow().notNull(),
},
(roles) => {
return {
cpk: primaryKey({ columns: [roles.name, roles.applicationId] }),
idIndex: uniqueIndex("roles_id_index").on(roles.id),
};
}
);

[realmikesolo]

@vats-24 could you please share your imports too?

[vats-24]

@realmikesolo
Here are the imports:-
import { text, timestamp, varchar } from "drizzle-orm/mysql-core";
import { pgTable, primaryKey, uniqueIndex, uuid, array } from "drizzle-orm/pg-core";

and here is the schema
export const roles = pgTable(
"roles",
{
id: uuid("id").defaultRandom().notNull(),
name: varchar("name", { length: 256 }).notNull(),
applicationId: uuid("applicationId").references(() => application.id),
permissions: text("permissions").array().$type(), // here i'm facing the problem
createdAt: timestamp("created_at").defaultNow().notNull(),
updatedAt: timestamp("updated_at").defaultNow().notNull(),
},
(roles) => {
return {
cpk: primaryKey({ columns: [roles.name, roles.applicationId] }),
idIndex: uniqueIndex("roles_id_index").on(roles.id),
};
}
);

[realmikesolo]

@vats-24 try to update your imports like this:

import { pgTable, primaryKey, uniqueIndex, uuid, text, timestamp, varchar } from 'drizzle-orm/pg-core';

export const roles = pgTable(
  'roles',
  {
    id: uuid('id').defaultRandom().notNull(),
    name: varchar('name', { length: 256 }).notNull(),
    applicationId: uuid('applicationId').references(() => application.id),
    permissions: text('permissions').array().$type(),
    createdAt: timestamp('created_at').defaultNow().notNull(),
    updatedAt: timestamp('updated_at').defaultNow().notNull(),
  },
  (roles) => {
    return {
      cpk: primaryKey({ columns: [roles.name, roles.applicationId] }),
      idIndex: uniqueIndex('roles_id_index').on(roles.id),
    };
  },
);

You import text, timestamp and varchar types from drizzle-orm/mysql-core. You should import them from drizzle-orm/pg-core because you use PostgreSQL. Also, you can remove array from imports

[realmikesolo]

Super