Drizzle Postgres schema is incorrect for unique constraints.

[ralphsmith80]

What is the improvement or update you wish to see?

The Postgres schema document here shows appling unique constraints like this.

(account) => [
  {
    compoundKey: primaryKey({
      columns: [account.provider, account.providerAccountId],
    }),
  },
]

However, the implementation for drizzle and the documentation as changed. It instead of using array notation [] it should use object notation {}.

(account) => {
  return {
    compoundKey: primaryKey({
      columns: [account.provider, account.providerAccountId],
    }),
  }
}

I originally thought this was a drizzle-orm bug and you can read about the details, tests, and fix (documentation) in that issue drizzle-team/drizzle-orm#3958.

Is there any context that might help us understand?

The drizzle-team/drizzle-orm#3958 issue is very thorough.

Does the docs page already exist? Please link to it.

https://orm.drizzle.team/docs/indexes-constraints#indexes