PostgreSQL table partitioning problem
I'm going to add my answer, which was correct in the comments, as the answer here.

Be specific about your types!

In your master table, you have point_date as a timestamp with time zone.  

In your CHECK constraint, you have used timestamp without time zone.  

Then, in your query, you just use point_date &gt;= '2015-08-25 00:00:00'::timestamp, thus using a timestamp type in your WHERE predicate.  

To fix your problems, make sure that all of these entries are referring to a consistent type.  In your comments above, you indicated that you changed all entries to refer to the type timestamp with time zone, and that it fixed your issues.