On Fri, 13 Aug 2021 at 17:23, Andrew Dunstan <andrew@dunslane.net> wrote:
> What do other DBMSs do?
I think MySQL defaults to WITH TIME ZONE, not sure, but I would bet a
few others follow the standard.
> This strikes me as primarily an education issue
> (I did a webinar on it not that long ago)
Yes, agreed.
> If you want to protect against people using tz-less timestamp, maybe an
> event trigger would be a solution, although maybe that's using a
> sledgehammer to crack a nut.
If you know about the issue, I guess you fix it in lots of different ways.
The issue is about those that don't know and my patch didn't help them
either. The only hope is to eventually change the default, so probably
the best thing is to apply pressure via the SQL Std process.
--
Simon Riggs http://www.EnterpriseDB.com/