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.

Comprehensive guide to PostgreSQL migrations - common errors, generated columns, full-text search, indexes, idempotent migrations, and best practices for database schema changes Source: pr-pm/prpm.

View raw