[BUG]: Composite Primary Key Not Automatically Creating

[JonathanAmdahl]

Report hasn't been filed before.

• I have verified that the bug I'm about to report hasn't been filed before.

What version of drizzle-orm are you using?

0.38.2

What version of drizzle-kit are you using?

0.30.1

Other packages

No response

Describe the Bug

I am creating a composite primary key on the fields: id, assetId, and inGameName. It never adds the primary key when pushing, I always have to add it manually.

export const product= pgTable('product', {
  id: varchar('id').notNull(),
  assetId: varchar('asset_id').notNull(),
  inGameName: varchar('in_game_name').notNull(),
  displayName: varchar('display_name').notNull(),
  type: varchar('type', { enum: typeValues }).notNull(),
  rarity: varchar('rarity', { enum: rarityValues }).notNull(),
  year: integer('year'),
  event: varchar('event'),
  chroma: boolean('chroma').notNull(),
  season: varchar('season'),
  defaultImageUrl: varchar('default_image_url').notNull(),
  obtainable: boolean('obtainable').notNull(),
  tradeable: boolean('tradeable'),
  createdAt: timestamp('created_at').notNull(),
  updatedAt: timestamp('updated_at').notNull()
}, (table) => {
    return [{
        item: primaryKey({name: 'item', columns: [table.id, table.assetId, table.inGameName]})
    }]
})

[JonathanAmdahl]

#3596 Didn't realize it was a postgres specific issue