Why {unique:true} doesn't throw?

If I add 3 users with the same email address, it adds them without any issue. How can I make sure the email is unique?

I also tried with:

email: varchar('email', { length: 256, unique: true, notNull: true }).primaryKey()

email: varchar('email', { length: 256, unique: true, notNull: true }).primaryKey()

const users = pgTable('users', {
    id: uuid('id').defaultRandom().primaryKey(),
    email: text('email', { length: 256, unique: true, notNull: true }),
    created_at: timestamp('created_at').notNull().defaultNow(),
})

const users = pgTable('users', {
    id: uuid('id').defaultRandom().primaryKey(),
    email: text('email', { length: 256, unique: true, notNull: true }),
    created_at: timestamp('created_at').notNull().defaultNow(),
})

Asseater Peter•8/9/23, 9:52 AM

cosbgnOP•8/9/23, 1:26 PM

Great, thanks

Asseater Peter•8/10/23, 5:59 AM

Test and let me know, also don't forget to apply this to your database...
The fact you wrote this incorrectly doesn't actually matter, since what is throwing the error here is the database and not the ORM

Asseater Peter•8/10/23, 6:02 AM

btw, don't forget to mark the thread as done for my OCD's sake if this fixed your issue