Re: Problem with constraint exclusion on partitions

Hey David,

> What version are you using?

Sorry, I'm on 9.3.4.

>Now() is a volatile function so the planner cannot omit partitions.
>
>Replace that with a constant and now it can.

I'm not sure what you mean- now() is a stable function:

cloud_test2=# \df+ now()

   Schema   | Name |     Result data type     | Argument data types |  Type
| Security | Volatility | Owner | Language | Source code |       Description

------------+------+--------------------------+---------------------+-------
-+----------+------------+-------+----------+-------------+-----------------
---------
 pg_catalog | now  | timestamp with time zone |                     | normal
| invoker  | stable     | pgres | internal | now         | current
transaction time


it's the timestamp at the start of the transaction- so the planner should
have a set value for all rows.

Am I missing something else?

Mike