Any partial index must also use CONCURRENTLY.

Getting ChatGPT to Write Accurate SQL Migrations Without Locking Production Tables

ChatGPT can draft SQL migrations fast, but the default output often contains ALTER TABLE statements that lock your production tables for minutes. Here's how to prompt it correctly and avoid downtime.