CockroachDB-only SQL that PostgreSQL rejects

FixBillingService
Shipped
August 10, 2026 at 2:14 PM UTC
Author
Kamo
Commit
424b6ae

CockroachDB spells the text type STRING; PostgreSQL and YugabyteDB use TEXT. 25 casts across native queries were still emitting CAST(x AS STRING) and ::STRING, which fail with 'type string does not exist'. That is what broke the mailbox dropdown on /messages -- SendableMailboxService could not run at all. Also in this sweep: UPSERT INTO -> INSERT .. ON CONFLICT DO UPDATE (OCRService) INVERTED INDEX -> CREATE INDEX .. USING GIN (email search vector) inline INVERTED INDEX inside CREATE TABLE hoisted out

All changes

Like what you see shipping?

Every one of these updates lands in your workspace automatically. Start free and watch it grow week after week.

Start Free ForeverView Pricing