On 1/26/21 1:16 PM, Simon Riggs wrote:
> On Tue, Jan 26, 2021 at 11:33 AM Vik Fearing <vik@postgresfriends.org> wrote:
>>
>> On 1/11/21 3:02 PM, Simon Riggs wrote:
>>> * UPDATE foo SET start_timestamp = DEFAULT should fail but currently doesn't
>>
>> I'm still in the weeds of reviewing this patch, but why should this
>> fail? It should not fail.
>
> It should not be possible for the user to change the start or end
> timestamp of a system_time time range, by definition.
Correct, but setting it to DEFAULT is not changing it.
See also SQL:2016 11.5 <default clause> General Rule 3.a.
--
Vik Fearing