I can't create a simple table..

What am I doing wrong?

import { pgTable, serial, text, varchar } from "drizzle-orm/pg-core";
 
export const users = pgTable('users', {
  id: serial('id').primaryKey(),
});


Type 'NotNull<PgSerialBuilderInitial<"id">>' is not assignable to type 'PgColumnBuilder<ColumnBuilderBaseConfig<ColumnDataType, string> & { data: any; }, object, object, ColumnBuilderExtraConfig>'.
  The types of 'array(...).array(...)._' are incompatible between these types.
    Type 'ColumnBuilderTypeConfig<{ name: "id"; dataType: "array"; columnType: "PgArray"; data: number[][]; driverParam: string | (string | number[])[]; enumValues: undefined; }, { baseBuilder: PgColumnBuilder<{ name: "id"; dataType: "array"; columnType: "PgArray"; data: number[]; driverParam: string | number[]; enumValues: u...' is not assignable to type 'ColumnBuilderTypeConfig<{ name: string; dataType: "array"; columnType: "PgArray"; data: any[][]; driverParam: string | (string | unknown[])[]; enumValues: string[] | undefined; }, { baseBuilder: PgColumnBuilder<{ name: string; dataType: "array"; columnType: "PgArray"; data: any[]; driverParam: string | unknown[]; en...'.
        Types of property 'baseBuilder' are incompatible.
          Type 'PgColumnBuilder<{ name: "id"; dataType: "array"; columnType: "PgArray"; data: number[]; driverParam: string | number[]; enumValues: undefined; }, object, object, ColumnBuilderExtraConfig>' is not assignable to type 'PgColumnBuilder<{ name: string; dataType: "array"; columnType: "PgArray"; data: any[]; driverParam: string | unknown[]; enumValues: string[] | undefined; }, object, object, ColumnBuilderExtraConfig>'.
            Type 'string' is not assignable to type '"id"'.ts(2322)


I am running on:
drizzle-orm: ^0.28.3
next: 13.4.19
postgres: ^3.3.5
drizzle-kit: ^0.19.13
typescript: 5.1.6
Screenshot_2023-08-23_at_1.35.25_am.png
Was this page helpful?