Re: TO_DATE Function unintended behavior when month value is greaterthan 12 - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: TO_DATE Function unintended behavior when month value is greaterthan 12
Date
Msg-id CAKFQuwaASjA69oNoc3Cxmse5F_58LuBXoctk4vNyt095X-MEAw@mail.gmail.com
Whole thread Raw
In response to TO_DATE Function unintended behavior when month value is greater than 12  (naidu rongali <rongalinaidu@gmail.com>)
List pgsql-bugs
On Fri, Mar 2, 2018 at 6:52 AM, naidu rongali <rongalinaidu@gmail.com> wrote:
though 8.2 is in deprecated versions, looks like 8.0.2 is released on 2009-02-02  as per https://www.postgresql.org/docs/8.0/static/release-8-0-20.html 


​That link points to 8.0.20 not 8.0.2 ... it would less egregious if running 8.0.26 since at least you would have been running the most up-to-date version of the 8.0 major release series but even that is over 7 years old at this point.

8.2[.x] is a completely different major version.

Upgrading 8.0 to a late 9 series or current 10 release will be non-trivial but, IMO, the decision not to should be a done with the consent and understanding of whomever ultimately owns the database and not through inattention.

David J.

pgsql-bugs by date:

Previous
From: "REIX, Tony"
Date:
Subject: BUG #14983: ERROR: duplicate key value violates unique constraint"oid_tbl_oid_key"
Next
From: Tom Lane
Date:
Subject: Re: BUG #15095: schema's owner can drop object's in his schema