DT
Drizzle Team•3mo ago
oof2win2

Cannot use pgEnum with aws aurora

Hi. I can't seem to use pgEnum with the AWS aurora adapter, as i keep getting the same error over and over. It seems weird, as intellisense doesn't say that the types are wrong at all when i am doing the update query, but pg returns an error ERROR: column "status" is of type "EmailStatus" but expression is of type text; Hint: You will need to rewrite or cast the expression.; Position: 31; SQLState: 42804 
await db
      .update(email)
      .set({ status: "sending", messageId: res.MessageId })
      .where(eq(email.emailId, msg.emailId))

export const emailStatus = pgEnum("EmailStatus", [
    "none",
    "sending",
    "sent",
    "cancelled",
])
export const email = pgTable(
    "email",
    {
        emailId: serial().primaryKey(),
        status: emailStatus().default("none"),
    },,
)
await db
      .update(email)
      .set({ status: "sending", messageId: res.MessageId })
      .where(eq(email.emailId, msg.emailId))

export const emailStatus = pgEnum("EmailStatus", [
    "none",
    "sending",
    "sent",
    "cancelled",
])
export const email = pgTable(
    "email",
    {
        emailId: serial().primaryKey(),
        status: emailStatus().default("none"),
    },,
)
2 Replies
neoney
neoney•3mo ago
I am also getting this issue.
neoney
neoney•3mo ago
https://github.com/drizzle-team/drizzle-kit-mirror/issues/421
GitHub
Bug Report: UUID Casting Issue in Drizzle KIT with PostgreSQL preve...
Bug Report: UUID Casting Issue in Drizzle Kit (Studio) with PostgreSQL Issue Description It seems the system is not casting correctly UUID fields as ::UUID, and that prevents update or deleting cre...

Did you find this page helpful?