CockroachDB-only SQL that PostgreSQL rejects

FixBillingService
Shipped
10 Agosti 2026, 14:14 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

Je, unaona nini kuhusu usafiri?

Kila moja ya hizi updates ardhi katika nafasi yako ya kazi moja kwa moja. Kuanza bure na kuangalia kukua wiki baada ya wiki.

Kuwa Huru MileleMtazamo wa bei