[BUG]: there is no unique or exclusion constraint matching the ON CONFLICT specification

[ghyath5]

What version of drizzle-orm are you using?

0.32.0

What version of drizzle-kit are you using?

0.23.0

Describe the Bug

import { sql, type SQL } from "drizzle-orm";
import type { AnyPgColumn } from "drizzle-orm/pg-core";

export function lower(col: AnyPgColumn): SQL {
  return sql`lower(${col})`;
}

users.ts schema:

export const users = pgTable(
  "users",
  {
    id: text("id")
      .primaryKey()
      .$defaultFn(() => createId()),
    name: varchar("name", { length: 255 }).notNull(),
    slug: varchar("slug", { length: 200 }), // Specified length
    email: varchar("email", { length: 255 }).notNull()
  },
  (table) => {
    return {
      slugUniqueIndex: uniqueIndex("user_slug_unique_idx").on(
        lower(table.slug)
      ),
      emailUniqueIndex: uniqueIndex("user_email_unique_idx").on(
        lower(table.email)
      ),
    };
  }
);

Upsert user query:

const [createdUser] = await tx
      .insert(users)
      .values({
        name: user.name,
        email: user.email,
        image: user.picture,
      })
      .onConflictDoNothing({
        target: users.email,
      })
      .returning({
        slug: users.slug,
        id: users.id,
        email: users.email,
      });
    console.log(createdUser);

I know it was defined as Lower email I tried multiple solutions with no luck

  .onConflictDoNothing({
      target: [users.email],
    })
    
    .onConflictDoNothing({
      target: [lower(users.email)],
    })`
    
    `Type 'SQL<unknown>' is missing the following properties from type 'PgColumn<ColumnBaseConfig<ColumnDataType, string>, {}, {}>': table, name, primary, notNull`
    
    `.onConflictDoNothing({
      target: sql`lower(${users.email})`,
    })`

Type 'SQL' is not assignable to type 'IndexColumn | IndexColumn[] | undefined'. Type 'SQL' is missing the following properties from type 'PgColumn<ColumnBaseConfig<ColumnDataType, string>, {}, {}>': table, name, primary, notNull

Although these were ts errors I tried the query also it failed and didn't work

Expected behavior

No response

Environment & setup

No response

[drewlev]

i have a similar issue

[ghyath5]

@drewlev Yeah this is an urgent issue to be resolved It's not difficult to be handled

[aidansunbury]

Also facing this issue

[L-Mario564]

Closing in favor of #2646.