On Wed, Jan 18, 2017 at 12:10 PM, Tom Lane wrote:
> More generally, this is the second serious bug we've found in the last
> month in the "transform" optimizations (see also bug #14479 and commit
> f0774abde). I'm starting to get the feeling that that idea was an
> attractive nuisance --- at the
I looked into bug #14504,
https://www.postgresql.org/message-id/20170118144828.1432.52...@wrigleys.postgresql.org
The problem is that timestamp_zone_transform() has the cute idea that
it can simplify timezone('UTC', timestamptzvalue) into a RelabelType
that claims the timestamptzvalue is just type
