Composite Primary Key not work

[senuLab]

Hello.

I defined Composite Primary Key and generate magration file, but primary constraint are nowhere to be found.
Is this a bug?
If you have a different way of defining it, I would love to know.

package versions
[email protected]
[email protected]
[email protected]

schema.ts

import { pgSchema, primaryKey, timestamp, varchar } from 'drizzle-orm/pg-core';

export const AppSchema = pgSchema('app');

export const User = AppSchema.table(
  'user',
  {
    id: varchar(),
    name: varchar().notNull(),
    email: varchar().notNull(),
    createdAt: timestamp().defaultNow().notNull(),
    updatedAt: timestamp().defaultNow().notNull(),
  },
  table => {
    return [
      {
        pk: primaryKey({ columns: [table.id, table.email] }),
        pkWithCustomName: primaryKey({
          name: 'custom_name',
          columns: [table.id, table.email],
        }),
      },
    ];
  },
);

drizzle/0000_migration.sql

CREATE SCHEMA "app";
--> statement-breakpoint
CREATE TABLE "app"."user" (
  "id" varchar,
  "name" varchar NOT NULL,
  "email" varchar NOT NULL,
  "created_at" timestamp DEFAULT now() NOT NULL,
  "updated_at" timestamp DEFAULT now() NOT NULL
);

drizzle.config.ts

import type { Config } from 'drizzle-kit';

export default {
  schema: './schema.ts',
  out: './drizzle',
  dialect: 'postgresql',
  dbCredentials: {
    url: ‘url’,
  },
  casing: 'snake_case',
  schemaFilter: ['app'],
} as const satisfies Config;

[zing-rsa]

this is the syntax that works for me:

export const User = AppSchema.table(
  'user',
  {
    id: varchar(),
    name: varchar().notNull(),
    email: varchar().notNull(),
    createdAt: timestamp().defaultNow().notNull(),
    updatedAt: timestamp().defaultNow().notNull(),
  },
  table => {
    return [
        primaryKey({ name: 'custom_name', columns: [table.id, table.email] }),
    ];
  },
);

it generates the following migration:

CREATE SCHEMA "app";
--> statement-breakpoint
CREATE TABLE "app"."user" (
	"id" varchar,
	"name" varchar NOT NULL,
	"email" varchar NOT NULL,
	"created_at" timestamp DEFAULT now() NOT NULL,
	"updated_at" timestamp DEFAULT now() NOT NULL,
	CONSTRAINT "custom_name" PRIMARY KEY("id","email")
);

drizzle composite key docs