Re: constraint_exclusion not working correctly

2024-08-15 Thread Tom Lane
PG Doc comments form writes: > I have noted that, in order for constraint exclusion to work correctly when > partitioning using inheritance, we must use simple comparisons in check > constraints (e.g., =, >=, <=, BETWEEN, etc.). If conditions are combined > using AND or OR, unnecessary partitions

constraint_exclusion not working correctly

2024-08-15 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/ddl-partitioning.html Description: Hello, I have noted that, in order for constraint exclusion to work correctly when partitioning using inheritance, we must use simple comparisons in che