Re: Question about new pg12 feature no-rewrite timestamp to timestamptz conversion

2019-05-20 Thread Bruce Momjian
On Mon, May 20, 2019 at 01:13:50PM -0500, Jeremy Finzel wrote: > I have a question about this (really exciting) feature coming in pg12: > > Allow ALTER TABLE .. SET DATA TYPE timestamp/timestamptz to avoid a table > rewrite when the session time zone is UTC (Noah Misch) > > In the UTC time zone,

Question about new pg12 feature no-rewrite timestamp to timestamptz conversion

2019-05-20 Thread Jeremy Finzel
I have a question about this (really exciting) feature coming in pg12: Allow ALTER TABLE .. SET DATA TYPE timestamp/timestamptz to avoid a table rewrite when the session time zone is UTC (Noah Misch) In the UTC time zone, the data types are binary compatible. We actually want to migrate all of o