"Christian Gonzalez" <christian.gonzalez@sigis.com.ve> writes:
> Description: Partitioning has problem with timestamp and timestamptz
> data types
In your example as given, you partition the table on "logdate", and then
add an unrelated column "logdatet" and seem to expect that the system
will think that's a partitioning condition.
I think you probably misstated your example, and meant to complain that
a table properly partitioned on a timestamptz column isn't behaving as
you'd wish for comparisons against "date" values. The problem here is
that the conversion is dependent on TimeZone, so is not immutable, so
the planner daren't depend on it to prove that the unwanted partition
tables need not be searched. You need to think harder about how
timezones should enter into your search rules...
regards, tom lane
