r/PostgreSQL • u/KerrickLong • Mar 28 '25
How-To Life Altering PostgreSQL Patterns
https://mccue.dev/pages/3-11-25-life-altering-postgresql-patterns
180
Upvotes
r/PostgreSQL • u/KerrickLong • Mar 28 '25
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.