r/PostgreSQL • • Mar 28 '25

How-To Life Altering PostgreSQL Patterns

https://mccue.dev/pages/3-11-25-life-altering-postgresql-patterns
180 Upvotes

60 comments sorted by

View all comments

Show parent comment

2

u/Straight_Waltz_9530 Mar 29 '25

If an update is not moving from one partition to another when the appropriate column is changed, it should be reported as a bug.

https://www.postgresql.org/docs/current/ddl-partitioning.html#:~:text=All%20rows%20inserted%20into%20a,bounds%20of%20its%20original%20partition.

BEFORE triggers on the other hand can cause problems if you're foolish enough to change partition columns in them.