10 replies

bit type goes to postgresql as a string

Hello!
I was recently creating my schemas for a project (I am using postgresql) and I set a column as bit(10), but drizzle-kit push passes it to postgresql as a string so that postgresql gives an error.

export const users = pgTable(
  "user",
  {
    id: bigint("id", { mode: "bigint" }).primaryKey(),
    test: bit("test", { dimensions: 10 }),
  }
);

export const users = pgTable(
  "user",
  {
    id: bigint("id", { mode: "bigint" }).primaryKey(),
    test: bit("test", { dimensions: 10 }),
  }
);

CREATE TABLE IF NOT EXISTS "formatting" (
             "id" bigint PRIMARY KEY NOT NULL,
            "test" "bit(10)",
);

CREATE TABLE IF NOT EXISTS "formatting" (
             "id" bigint PRIMARY KEY NOT NULL,
            "test" "bit(10)",
);

ERROR:  type "bit(10)" does not exist at character 161

ERROR:  type "bit(10)" does not exist at character 161

Drizzle Team•2y ago•

10 replies

Pure

bit type goes to postgresql as a string

export const users = pgTable(
  "user",
  {
    id: bigint("id", { mode: "bigint" }).primaryKey(),
    test: bit("test", { dimensions: 10 }),
  }
);

export const users = pgTable(
  "user",
  {
    id: bigint("id", { mode: "bigint" }).primaryKey(),
    test: bit("test", { dimensions: 10 }),
  }
);

CREATE TABLE IF NOT EXISTS "formatting" (
             "id" bigint PRIMARY KEY NOT NULL,
            "test" "bit(10)",
);

CREATE TABLE IF NOT EXISTS "formatting" (
             "id" bigint PRIMARY KEY NOT NULL,
            "test" "bit(10)",
);

ERROR:  type "bit(10)" does not exist at character 161

ERROR:  type "bit(10)" does not exist at character 161

bit type goes to postgresql as a string

Similar Threads

bit type goes to postgresql as a string

Similar Threads

Similar Threads

Similar Threads