Default value for Array creates an incorrect SQL migration

I'm currently adding a new field roles to my PG table, users, such as:

export const users = pgTable(
  'users',
  {
    user_id: text('user_id').primaryKey(),
    balance: integer('balance').notNull().default(0),
    roles: text('roles').array().default(['user']),
  },
  (table) => {
    return {
      user_idIdx: uniqueIndex('user_id_idx').on(table.user_id),
    };
  },
);

export const users = pgTable(
  'users',
  {
    user_id: text('user_id').primaryKey(),
    balance: integer('balance').notNull().default(0),
    roles: text('roles').array().default(['user']),
  },
  (table) => {
    return {
      user_idIdx: uniqueIndex('user_id_idx').on(table.user_id),
    };
  },
);

The problem is that when I generate the SQL schema it returns this:

ALTER TABLE "users" ADD COLUMN "roles" text[] DEFAULT user;

ALTER TABLE "users" ADD COLUMN "roles" text[] DEFAULT user;

which is wrong since it thinks it's referencing to a user table but not just a default string value called user

0 Replies

No replies yetBe the first to reply to this messageJoin

Gaming

Programming

Default value for Array creates an incorrect SQL migration