Postgres Pro
Downloads
Home   >   mailing lists

Re: [BUGS] BUG #14841: Remove TIME WITH TIME ZONE type - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: [BUGS] BUG #14841: Remove TIME WITH TIME ZONE type
Date
Msg-id CAKFQuwaOU51pZRAfjoqKFWsm7+JdyM4OE8RCjvLRwOJnN+r+eQ@mail.gmail.com
Whole thread Raw
In response to Re: [BUGS] BUG #14841: Remove TIME WITH TIME ZONE type  (Eduardo Pérez Ureta <edpeur@gmail.com>)
List pgsql-bugs
Tree view
On Tue, Oct 3, 2017 at 2:19 PM, Eduardo Pérez Ureta <edpeur@gmail.com> wrote:
Of course, this fix will not need to be included in any current supported release.
But, would you remove the TIME WITH TIME ZONE type in a new major release?

What is the priority for PostgreSQL, standards conformance, or making a useful product without broken features?

In this case neither - the priority here is not breaking people's working applications when they upgrade from one major release to the next (and minimizing the amount of pain involved when migrating from other SQL-standard compliant databases to ours).

​The SO post isn't even a question from someone being tricked/confused into using "timetz" but rather a intellectual exercise into why it exists.

David J.

pgsql-bugs by date:

Previous
From: Eduardo Pérez Ureta
Date:
Subject: Re: [BUGS] BUG #14842: TIMESTAMP WITH TIME ZONE and TIMESTAMP WITHOUTTIMEZONE should not be comparable
Next
From: "David G. Johnston"
Date:
Subject: Re: [BUGS] BUG #14842: TIMESTAMP WITH TIME ZONE and TIMESTAMP WITHOUTTIMEZONE should not be comparable