Re: No-rewrite timestamp<->timestamptz conversions - Mailing list pgsql-hackers

From Noah Misch
Subject Re: No-rewrite timestamp<->timestamptz conversions
Date
Msg-id 20190226201235.GB1655734@rfd.leadboat.com
Whole thread Raw
In response to Re: No-rewrite timestamp<->timestamptz conversions  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
On Tue, Feb 26, 2019 at 02:29:01PM +0000, Simon Riggs wrote:
> Looks good, would need docs.

The ALTER TABLE page just says "old type is either binary coercible to the new
type or an unconstrained domain over the new type."  Avoiding rewrites by way
of a prosupport function or the at-timestamp-v2.patch approach is essentially
another way to achieve binary coercion.  So far, we haven't documented the
individual data types affected.  Since we don't mention e.g. varchar(x) ->
varchar(x+k) explicitly, I plan not to mention timestamp explicitly.


pgsql-hackers by date:

Previous
From: Markus Winand
Date:
Subject: Index INCLUDE vs. Bitmap Index Scan
Next
From: Peter Geoghegan
Date:
Subject: Re: Remove Deprecated Exclusive Backup Mode