postgres-migrations

SKILL.md

Cause: Subquery in SELECT/CASE references columns from outer query that aren't in GROUP BY.

Solution: Use CTE (Common Table Expression) to separate aggregation from subqueries:

Cause: PostgreSQL requires functions in indexes/generated columns to be IMMUTABLE.

PostgreSQL 迁移综合指南 - 常见错误、生成列、全文搜索、索引、幂等迁移以及数据库架构更改的最佳实践 来源：pr-pm/prpm。

查看原文