Re: Default to TIMESTAMP WITH TIME ZONE? - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: Default to TIMESTAMP WITH TIME ZONE?
Date
Msg-id CAKFQuwbf=TvVOpnqCZOsip6fHpeB-ZhXq61S08-GNfW18O2yDg@mail.gmail.com
Whole thread Raw
In response to Re: Default to TIMESTAMP WITH TIME ZONE?  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
Responses Re: Default to TIMESTAMP WITH TIME ZONE?  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
On Fri, Aug 13, 2021 at 12:33 AM Gavin Flower <GavinFlower@archidevsys.co.nz> wrote:

I always use the tz version, except when I forget.

I find it nearly impossible for me to forget how this works.  But that is probably because I just pretend that the standard, multi-word, data types don't even exist.  It's not that "timestamp" defaults to "WITHOUT TIME ZONE" but rather that there are only two types in existence: timestamp and timestamptz.  It's self-evident which one doesn't handle time zones.


Suspect that it is extremely rare when one would not want to use the TZ
option, which suggests to me that using TZ should be the default.


I would agree, but at this point I'd leave it up to documentation and educational materials to teach/encourage, not runtime behaviors.

David J.

pgsql-hackers by date:

Previous
From: Ronan Dunklau
Date:
Subject: Proposal: More structured logging
Next
From: Alexander Kukushkin
Date:
Subject: Re: pg_settings.pending_restart not set when line removed